Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ------------------------
- --Q5
- SELECT DISTINCT a.ARRIVAL_DATE, a.departure_date
- FROM DOCKING a
- WHERE (a.DEPARTURE_DATE-a.ARRIVAL_DATE) >= ALL (SELECT (b.DEPARTURE_DATE-b.ARRIVAL_DATE)
- FROM DOCKING b
- WHERE b.sid <> a.sid);
- ------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement