1.

Find Out Nth Highest Salary From Emp Table?

Answer»

SELECT DISTINCT (a.sal) FROM EMP A WHERE &AMP;N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
For E.g.:-
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);
For E.g.:-
Enter value for n: 2
SAL
---------
3700


Discussion

No Comment Found

Related InterviewSolutions