time calculation and differnet between two rows

[alhakimi]

Dear All

I have table that has name | flightdate| from | to | flight number | booking datetime|
Name1 : 10/10/2013: london| frankfurt| 100| 05/10/2013 10:00pm
Name2 : 10/10/2013: london| frankfurt| 100| 05/10/2013 11:00pm
Name1 : 10/10/2013: london| frankfurt| 100| 02/11/2013 6:00pm

how can i get number of rows that has flown same sector same details with small time differnet between first booking and the second booking.

thank you

Hakimi

[Rabbit]

Join the table to itself on the details you want the same and filter for those where the time difference is "small", however you define small.