SQL: howto retrieve only the first row?

[Peter Primrose]

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]

very untested statement

select t1.ticket from  mytable t1 where 
    t1.origin = 'JFK' 
and t1.code = 873 
and not exists
   (
     select 1 from mytable t2 where 
       t2.ticket = t1.ticket
   and t2.code = t1.code
   and t2.id < t1.id
   )