Ashraful's Blog: How to get 3rd, 5th or 6th i.e. N'th highest Salar...

 How to get 3rd, 5th or 6th i.e. N'th highest Salary: 

SELECT * FROM EMPLOYEE E    WHERE 2 = (SELECT COUNT(DISTINCT E1.SALARY)    FROM EMPLOYEE E1    WHERE E1.SALARY>E.SALARY) Here, 2= 3