You can also do it by the following query .. select * from (select name,

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 / shriram

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

Answer Posted / shriram

You can also do it by the following query ..

select * from (select name,salary,rank() over(order by
salary desc as r) from employee) where r = 2;

The above query returns the 2nd highest salary from the table.

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql better than excel?

1062

Can we create clustered index without primary key?

901

Is oracle sql free?

928

What are functions in sql?

906

what are the different type of normalization? : Sql dba

974

What is sql rowcount?

952

What is procedure and function in sql?

930

What is transaction control language (tcl)?

1074

What is sql comments?

1038

what is an alias command? : Sql dba

1011

Is sql a backend language?

1043

differentiate between float and double. : Sql dba

992

What is dbo in sql?

921

How do I truncate a sql log file?

1008

What is auto increment feature in sql?

1069