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 single index for multiple columns?

1038

Why does oracle 9i treat an empty string as null?

1057

How do I reset a sequence in oracle?

1099

Explain about achiever in sql?

1040

How to create a stored procedure in oracle?

1105

what's query optimization and without use of IN AND Exist can we get another way data from query

2142

How to assign query results to variables?

1051

How to delete all rows a table in oracle?

1068

What is define in oracle?

1060

How to filter out duplications in the returning rows using oracle?

1018

How do we get field detail of a table?

1081

Â What are the oracle DML commands possible through an update strategy?

1064

What is truncate oracle?

972

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1046

What are the benefits of ordbms?

1088