Guest User

Untitled

a guest
Jun 20th, 2018
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.32 KB | None | 0 0
  1. SELECT * FROM people ORDER BY age DESC LIMIT 1;
  2.  
  3. SELECT * FROM people WHERE MAX(age);
  4.  
  5. SELECT * FROM people WHERE age IN (SELECT DISTINCT age FROM people ORDER BY age DESC LIMIT 3)
  6.  
  7. SELECT * FROM people WHERE age = (SELECT MAX(age) FROM people)
  8.  
  9. SELECT * FROM people WHERE age =
  10. (select MAX(age) from people);
Add Comment
Please, Sign In to add comment