aspose file tools*
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
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: 2477
    
    7

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
criteriaFind with java.util.regex
Flight and segment
Do you have what it takes to be President?
Application failover
Problem in MDB instance !!! Help Needed