select * from emp a where 2=(select count(distinct sal) from emp b where a

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / anil_abbireddy

Answer Posted / anil_abbireddy

select * from emp a where 2=(select count(distinct sal)
from emp b where a.sal<=b.sal)

Is This Answer Correct ?

44 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Is primary key clustered index?

945

What is keys and its types?

1069

What is multiple partition?

962

What is a full join?

968

What is the difference between inner join and natural join?

1000

Can we use loop in sql?

967

Does normalization improve performance?

1031

What is procedure explain with program?

1015

what is the difference between blob and text? : Sql dba

1012

What is the mutating table and constraining table?

1023

What is bulk collect in pl sql?

1086

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

982

How many sql are there?

990

What are the types of queries in sql?

1081

How do I view tables in sql developer?

934