Guest User

Untitled

a guest
Jan 19th, 2018
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. SELECT * FROM [Orders] WHERE OrderDate >
  2. (Select OrderDate FROM [Orders] WHERE CustomerId = 34 ) ORDER BY OrderDate ASC LIMIT 1
  3.  
  4. SELECT * FROM [PERSON ]
  5. WHERE (
  6. death_date_year > (Select death_date_year FROM [PERSON] WHERE id = 34 )
  7. OR death_date_month > (Select death_date_month FROM [PERSON] WHERE id = 34 )
  8. OR death_date_day > (Select death_date_day FROM [PERSON] WHERE id = 34 )
  9. ORDER BY death_date_year death_date_month death_date_day ASC LIMIT 1
Add Comment
Please, Sign In to add comment