select min(salary) from (select salary from table

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / deepa

Answer Posted / deepa

select min(salary) from (select salary from table_name order by salary desc) where rownum<3;

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is mutating trigger?

1028

what is the syntax used for partition in tsql? : Transact sql

1024

How long it takes to learn pl sql?

1022

Give the order of sql select?

1144

What is the difference between null value, zero, and blank space?

1212

How does a covering index work?

972

What is sql lookup?

932

What is a database trigger?

1078

Explain the select statement in sql?

1120

What is orm in sql?

1052

How do I create a memory optimized filegroup?

973

Which are the different types of indexes in sql?

1067

How is debugging done?

989

what are tables and fields? : Sql dba

1067

Is sql easier than java?

1022