select top 1 Coumn_Name from (select top 2 Coumn_Name from Table

Write query to fetch second maximum salary from employee table.

Question Posted / vijayalakshmi

Answer Posted / vijayalakshmi

select top 1 Coumn_Name from (select top 2 Coumn_Name from Table_name order by Coumn_Name desc) b order by Coumn_Name

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to create a new table by selecting rows from another table?

1151

How to drop an index?

1015

Can select statements be used on views in oracle?

1084

What is a nvl function? How can it be used?

1099

How to define a sub function?

1202

What is oracle in java?

1018

How can we delete duplicate rows in a table?

1039

Difference between open_form and call_form in oracle.

1224

What is an oracle user account?

1043

Explain user account with reference to oracle.

1031

What exactly do quotation marks around the table name do?

1027

How to experiment a data lock in oracle?

1112

What is a read only transaction in oracle?

1080

Is there any function in oracle similar like group_concat of mysql?

1109

Difference between the “verify” and “feedback” command?

1429