Forums Register Login

SQL: howto retrieve only the first row?

+Pie Number of slices to send: Send
Hey all,

I have the following table and wonder how can I select all tickets that the FIRST Origin is JFK and code is 873?



In this example I expect only Ticket=1088 to return because ticket 1005 doesn�t start at JFK.

Thanks for any pointers
+Pie Number of slices to send: Send
very untested statement
passwords must contain 14 characters, a number, punctuation, a small bird, a bit of cheese and a tiny ad.
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 965 times.
Similar Threads
criteriaFind with java.util.regex
Application failover
Problem in MDB instance !!! Help Needed
Flight and segment
Do you have what it takes to be President?
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 29, 2024 05:41:25.