--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
16390 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 a table in a database ? : Sql dba

1047

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1073

What is pl sql collection?

978

Is left join and outer join same?

1076

how many values can the set function of mysql take? : Sql dba

994

What is character functions?

1066

How to get help at the sql prompt?

1122

How do you remove duplicate records from a table?

945

How do you drop a trigger?

997

Name some usages of database trigger?

1022

What is rename in sql?

979

How exception is different from error?

1022

How do you modify a column in sql?

1002

What is data control language?

994

Can we use the cursor's to create the collection in PL/SQL?

1031