top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Find out nth highest salary from emp table in Oracle?

+1 vote
153 views
Find out nth highest salary from emp table in Oracle?
posted May 29, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes
  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 Jun 1, 2015 by Arun Gowda
Similar Questions
+1 vote

How we can get nth max salary from Employee Table (EMP_ID, Salary)

Emp_id salary
1 1000
3 2000
4 16000
2 10000
7 19000
8 12000

e.g. for 3rd max salary, salary is 12000 so answer will be emp_id : 8

...