Friday, 20 May 2011

Find the nth maximum salary

SELECT ENAME, SAL FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT(SAL)) FROM EMP B WHERE A.SAL<=B.SAL);

No comments:

Post a Comment