Hi, Select * from emp e where 2>= (select count(sal) from e

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

Question Posted / satya_k21

Answer Posted / satya_k21

Hi,

Select * from emp e where 2>= (select count(sal) from
emp e where sal>=e.sal) order by desc.

Let me know if it is wrong..

Regards,
Satya.K

Is This Answer Correct ?

11 Yes

16 No

Please Help Members By Posting Answers For Below Questions

what is a join? : Sql dba

1029

How many types of index are there?

1032

What is crud diagram?

944

What is a dynamic query?

1018

Is it possible to pass parameters to triggers?

1099

What is normalization sql?

1051

What are the two types of exceptions in pl/sql?

1049

Is not equal in sql?

1010

What is primary and foreign key?

1059

how to do backup entire database? : Transact sql

1143

What are triggers and its types?

1055

What is group by in sql?

1083

What are local and global Indexes and where they are useful.

1440

What is the limitation on the block size of pl/sql?

983

How does sql*loader handles newline characters in a record? : aql loader

1041