wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQL: howto retrieve only the first row? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQL: howto retrieve only the first row?" Watch "SQL: howto retrieve only the first row?" New topic
Author

SQL: howto retrieve only the first row?

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
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
Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2491
    
    8

very untested statement


OCUP UML fundamental and ITIL foundation
youtube channel
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL: howto retrieve only the first row?
 
Similar Threads
Do you have what it takes to be President?
Problem in MDB instance !!! Help Needed
Flight and segment
Application failover
criteriaFind with java.util.regex