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

What is out parameter used for eventhough return statement can also be used in pl/sql?

1124

What is data control language (dcl)?

1205

What is an ndf file?

1063

What is a common use of group by in sql?

1096

What is sql integrity?

1242

What is scalar function?

1096

What is numeric function sql?

1107

how to enter characters as hex numbers? : Sql dba

1103

How many types of cursors are available in pl/sql?

1165

what is an alias command? : Sql dba

1172

Does execute immediate commit?

1291

Which join condition can be specified using on clause?

1014

List different type of expressions with the example.

973

what is an index? : Sql dba

1041

What is a dynamic query?

1073