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

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

Question Posted / omkar hendre

Answer Posted / omkar hendre

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How does sql profiler work?

1023

Which one is better sql or oracle?

974

What is sap sql anywhere?

1088

Is oracle and sql same?

1018

How to use sql*plus built-in timers?

1209

Is microsoft sql free?

1107

Explain correlated query work?

1059

What is a recursive stored procedure?

1188

how to escape special characters in sql statements? : Sql dba

1041

Is postgresql a nosql database?

1166

What is the difference between the conventional and direct path loader? : aql loader

1157

What are the rules to be applied to nulls whilst doing comparisons?

1326

what is difference between delete and truncate commands? : Sql dba

1138

Explain how to use transactions efficiently : transact sql

987

Which type of cursor is used to execute the dml statement?

961