select * from (select salary,dense_rank() over (order by salary) kk from

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 / prativa mishra

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

Answer Posted / prativa mishra

select *
from
(select salary,dense_rank() over (order by salary) kk from table_name)
where kk=2

Is This Answer Correct ?

7 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is pragma in pl sql?

1116

State few characteristics of pl/sql?

971

What are the different ddl commands in sql?

1171

How would you convert date into julian date format?

1006

Is sql a backend language?

1100

What is error ora-01000: maximum open cursors exceeded

1147

define join and explain different type of joins? : Sql dba

954

What are records give examples?

1012

Is sql harder than python?

1110

What is the difference among union, minus and intersect?

1002

What is trigger with example?

1104

How many types of cursors supported in pl/sql?

1196

What is delimiter sql?

1013

How do I turn a list into a table?

963

What does the hierarchical profiler does?

1061