Find Out Nth Highest Salary From Emp Table

1.	Find Out Nth Highest Salary From Emp Table
Answer» SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (B.sal)) FROM EMP B WHERE a.sal&LT;=b.sal); Enter VALUE for n: 2 SAL --------------- 3700 SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); Enter value for n: 2 SAL --------------- 3700

Answer»

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (B.sal)) FROM EMP B WHERE a.sal&LT;=b.sal);

Enter VALUE for n: 2
SAL
---------------
3700

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

Enter value for n: 2
SAL
---------------
3700

Discussion