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

Explain a segment?

1020

What is not equal to in oracle?

953

How many types of segments in Oracle?

1014

How many types of cluster table in Oracle?

987

What are the oracle differences between nvl and coalesce

1068

definition of cluster and non-clustered index?

2962

What is an index associated with a constraint?

975

How to define a record variable to store a table row?

1005

How to select some columns from a table in oracle?

1005

What is the scope of a local variable?

998

How do you find current date and time in oracle?

989

What are the limitations oracle database 10g xe?

979

What are the differences between number and binary_float in oracle?

1054

What are the different types of record groups in oracle? Explain each of them

972

What is columnar storage what is the advantage?

985