select max(sal) from emp ((select sal from emp)-(select max (sal) from emp

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

Question Posted / varun

Answer Posted / varun

select max(sal) from emp ((select sal from emp)-(select max
(sal) from emp))

Is This Answer Correct ?

5 Yes

8 No

Please Help Members By Posting Answers For Below Questions

Is sql open source?

979

Explain the order of sql statement execution?

1049

What is the difference between row level and statement level trigger?

1025

How are functions and procedures called in PL/SQL?

1236

Why use stored procedures?

1098

Why is pl sql used?

987

What are sql indexes?

1004

Does sql*plus have a pl/sql engine?

1076

Which sql statement is used to delete data from a database?

964

what is transaction? : Sql dba

1011

Define implicit and explicit cursors.

1150

Is sql better than access?

1021

What are the types of triggers in sql?

1089

what is difference between delete and truncate commands? : Sql dba

1135

What are the uses of merge?

1167