Rakesh Reddy
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
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment