How do you select seventh highest value?

Answer 1

SINCE THE QUESTION IS NOT SPECIFIC TO FIND 7TH HIGHEST SALARY OF AN EMPLOYEE OR ANYTHING ELSE,LET ME GIVE YOU THE SOLUTION FOR 7TH MAX SAL FROM A EMP TABLE. SELECT * FROM EMP E

WHERE 7=(SELECT COUNT(DISTINCT SAL) FROM EMP F WHERE E.SAL<=F.SAL);