Wednesday, April 25, 2012

Second Max Salary Query


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

No comments:

Post a Comment