Advertisement
Guest User

Untitled

a guest
Nov 21st, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. ------------------------
  2. --Q5
  3. SELECT DISTINCT a.ARRIVAL_DATE, a.departure_date
  4. FROM DOCKING a
  5. WHERE (a.DEPARTURE_DATE-a.ARRIVAL_DATE) >= ALL (SELECT (b.DEPARTURE_DATE-b.ARRIVAL_DATE)
  6. FROM DOCKING b
  7. WHERE b.sid <> a.sid);
  8. ------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement