SELECT salary FROM employee e1 WHERE 3-1 = (SELECT COUNT(DISTINCT salary) FROM employee e2 WHERE e2.salary > e1.salary)

 

Our updated SQL interview questions queries for freshers are the best online resource to help you prepare for the upcoming interviews.

BY Best Interview Question ON 20 Apr 2019