Advertisement
apl-mhd

At least 3 other salary

Aug 2nd, 2018
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.12 KB | None | 0 0
  1. SELECT * FROM
  2. employees e1
  3. WHERE 3<=(
  4.  
  5.     SELECT COUNT(*)
  6.     FROM employees e2
  7.     WHERE e1.SALARY > e2.SALARY
  8.  
  9. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement