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 ?

30 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Mention what does plv msg allows you to do?

1127

What does (*) mean in sql?

955

What is a data manipulation language?

1028

Which query operators in sql is used for pattern matching?

972

What is an intersect?

1110

How do I find duplicates in two columns?

1175

Does sql backup shrink transaction log?

984

How to revise and re-run the last sql command?

1169

What are the most important characteristics of pl/sql?

1165

what are null values? : Sql dba

960

How to sort the rows in sql.

1080

Explain table and field in sql?

1068

Which is faster truncate or drop?

1047

What is a sql select statement?

1042

How can I change database name in sql?

1088