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

What is an oracle transaction?

1158

How to concatenate two text values in oracle?

1120

How to list all tables in your schema?

1065

Why is oracle so popular?

1010

Explain the use of parfile option in exp command.

1079

Which is better Oracle or MS SQL? Why?

6406

What are the attributes that are found in a cursor?

1086

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

1047

How to rename an existing table?

1135

How to write date and time interval literals in oracle?

1041

How to convert character types to numeric types?

1141

What is a static data dictionary in oracle?

1121

How to display employee records who gets more salary than the average salary in the department?

1074

What do you mean by redo log file mirroring?

1042

What is a schema in oracle?

1026