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 is user in sql?

584

what does myisamchk do? : Sql dba

558

What are the types of dbms?

547

what is commit? : Sql dba

619

What is use of package in pl sql?

534

Can we rollback delete command?

516

Explain autonomous transaction.

640

how to present a past time in hours, minutes and seconds? : Sql dba

566

How do I write a sql query in pgadmin 4?

558

What is the limitation on the block size of pl/sql?

532

what are the properties and different types of sub-queries? : Sql dba

506

How to rename a column in the output of sql query?

539

What is java sql driver?

550

What is pl sql variable?

512

Can we use join in subquery?

567