DEVFYI - Developer Resource - FYI

Find out nth highest salary from emp table?

ORACLE Interview Questions and Answers (Part 4)


(Continued from previous question...)

590. 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);
For Eg:-
Enter value for n: 2
SAL
---------
3700


591. Suppose a customer table is having different columns like customer no, payments.What will be the query to select top three max payments?

SELECT customer_no, payments from customer C1
WHERE 3<=(SELECT COUNT(*) from customer C2
WHERE C1.payment <= C2.payment)

(Continued on next question...)

Other Interview Questions