answersLogoWhite

0


Best Answer

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);

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you select seventh highest value?
Write your answer...
Submit
Still have questions?
magnify glass
imp