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

How do I truncate a word?

1002

What is parallel hint?

1223

What is indexing oracle sql?

1026

Is trigger a stored procedure?

887

How to run sql statements with oracle sql developer?

1000

How do I find duplicates in sql?

879

What is pl sql block in dbms?

952

What is having clause in sql?

929

What is difference between my sql and sql?

997

What are some emotional triggers?

930

What is union and union all keyword in sql and what are their differences?

1047

What is sqlerrd?

921

Why stored procedure is faster than query?

951

What is an alias command?

1007

What is the difference between clustered and non-clustered indexes?

1029