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 cursor. write example of it. What are the attributes of cursor.

1466

Define tables and fields in a database

1181

What is numeric function sql?

1108

Should I use mbr or gpt?

1063

Explain aggregate functions are available there in sql?

1051

How show all rows in sql?

1060

what is “go” in t-sql? : Transact sql

1158

How many scalar data types are supported in pl/sql?

1106

What jobs use sql?

1033

How do I filter in sql profiler?

1055

What is pl sql block structure?

1095

How sql query is executed?

1187

What is a null value?

1191

what is a table in a database ? : Sql dba

1090

What are the possible values that can be stored in a boolean data field?

1042