Advertisement
apl-mhd

another way max salary

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