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

What type of database is sql?

1021

How many types of cursors are available in pl/sql?

1104

What are user defined functions?

1012

How many types of literals are available in pl sql?

1112

What is the use of double ampersand (&&) in sql queries? Give an example

1139

Does oracle use sql?

926

How can I delete duplicate rows?

1012

What are the different types of dbms?

1009

how to concatenate two character strings? : Sql dba

1095

Why schema is used in sql?

1047

What is the order of sql select?

1041

What is the use of procedures?

973

when MSQL8.0 is in market

2074

What are field types?

997

Enlist the advantages of sql.

1001