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

How do you pronounce sql?

1018

how does a local variable is defined using t-sql? : Transact sql

1019

Which one is faster ienumerable or iqueryable?

937

What is pl sql block structure?

1044

Can we call dml statement in function?

1061

what are the properties and different types of sub-queries? : Sql dba

1034

Can you have more than one trigger on a table?

1003

How do I find duplicates in a single column in sql?

1022

Is sql a dbms?

1017

what is not null constraint? : Sql dba

1037

How does sql developer connect to oracle database?

1006

Can procedure in package be overloaded?

1085

What are the types pl/sql code blocks?

1137

How can we solve sql error: ora-00904: invalid identifier?

1248

What does data normalization mean?

971