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 get the Installed Oracle Version Information ?

1117

How to do clean up if create database failed?

1026

What are the execution control statements?

1062

What is using clause and give example?

1031

What is oracle latest version?

1092

How to run create database statement?

1028

How to get execution path reports on query statements?

978

How to define a data field as not null?

1103

How view is different from a table?

1026

How to define a specific record type?

1082

What is a read write transaction in oracle?

1083

How to rollback the current transaction in oracle?

1049

What do you mean by cdb and pdb in oracle 12c?

1057

How to resolve name conflicts between variables and columns?

1026

What happens if the update subquery returns multiple rows?

1111