Posts

Showing posts from March, 2016

display Nth highest salary.

SELECT   e1.sal FROM employee e1 WHERE &N = (SELECT COUNT(DISTINCT (sal) )             FROM employee e2             WHERE e1.sal <= e2.sal);