select * from emp where 2(select count(distinct sal) from emp e where sal&

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

Question Posted / prasanna

Answer Posted / prasanna

select * from emp where 2(select count(distinct sal) from
emp e where sal>=e.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we use two order by clause in query?

964

What is the function that is used to transfer a pl/sql table log to a database table?

1007

Explain how to use transactions efficiently : transact sql

973

Does truncate require commit?

964

What is set transaction?

1035

What does cursor do in sql?

1014

What is sql lookup?

915

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

1145

What is dml statement?

949

How do I add a primary key to a table?

1040

What are views in sql?

976

how do you login to mysql using unix shell? : Sql dba

1077

How many joins in sql?

1002

explain the difference between bool, tinyint and bit. : Sql dba

992

How do I run sql?

1176