DBA > Job Interview Questions > DATABASE Administrator (DBA) Interview Questions and Answers

Find out nth highest salary from emp table

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

64. Find out nth highest salary from emp table

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

(Continued on next question...)

Other Job Interview Questions