Q:

Highest value of sequence for each booking

I need to retrieve all the values of Booking_ID but with their highest individual respective 'Sequence' values. How can I do this? 

So the result should be something like this :
BookingID Destination    Destination
1010      199591             1 <--- I need only this row
1011      188061             1 <--- I need only this row
1012      118628             1 <--- this should not be here
1012      188061             2 <--- this should not be here
1012      169420             3 <--- I need only this row
1013      179555             1 <--- I need only this row
1014      179037             1 <--- I need only this row
1015      499172             1 <--- I need only this row
1016      189558             1 <--- I need only this row
1017      018953             1 <--- I need only this row
1018      169420             1 <--- I need only this row
1019      169420             1 <--- I need only this row
1020      098585             1 <--- This should not be here
1020      098269             2 <--- I need only this row
1021      499172             1 <--- I need only this row

A:

select b1.*
  from booking b1 
 where not exists ( select 1 
                      from booking b2
                     where b2.id       = b1.id 
                       and b2.sequence > b1.sequence
                  )

