--2 ND HIGHEST SALARY SELECT MAX(SALARY) FROM HR.EMPLOYEES WHERE SALARY &

How to retrieve a second highest salary from a table?
Note:Suppose salaries are in duplicate values
eg:
Name Sal
Malli 60000
Pandi 60000
Rudra 45000
Ravi 45000

Question Posted / welcomeashwin

10 Answers
15938 Views
Mind Tree, Polaris, Sonata, I also Faced
E-Mail Answers

Answer Posted / welcomeashwin

--2 ND HIGHEST SALARY
SELECT MAX(SALARY) FROM HR.EMPLOYEES
WHERE SALARY < (SELECT MAX(DISTINCT(SALARY)) FROM
HR.EMPLOYEES);

--N TH HIGHEST SALARY
SELECT * FROM HR.EMPLOYEES EMP1
WHERE &N=(
SELECT COUNT(DISTINCT(SALARY))
FROM HR.EMPLOYEES EMP2
WHERE EMP1.SALARY<=EMP2.SALARY
);

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is mdf ldf and ndf?

926

What is 19 null in sql?

893

What is Collation Sensitivity ? What are the various type ?

901

Show the two pl/sql cursor exceptions.

1103

What is an invalid partition table?

958

does sql support programming? : Sql dba

989

What is sql indexing?

962

What does (+) mean in sql joins?

1006

What is a join?

1019

What is trigger types in sql?

941

What is pl sql in oracle?

988

Can we use delete in merge statement?

998

Enlist the advantages of sql.

935

When you have to use a default "rollback to" savepoint of plvlog?

1123

Advantages and disadvantages of stored procedure?

1057