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 the difference between translate and replace?

788

How to install oracle odbc drivers?

822

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

734

What is the recommended interval at which to run statspack snapshots, and why?

2635

What is the order of defining local variables and sub procedures/functions?

803

Is java required for oracle client?

706

How to store only time; not date and time?

715

What is data block in Oracle?

817

What is background process in Oracle?

815

What is the difference between translate and replace in oracle?

886

Difference between pre-select and pre-query

757

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1668

What is an oracle function?

810

How to create id with auto_increment on oracle?

733

What are the differences between lov and list item?

740