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 are date and time data types in mysql? : Sql dba

490

Determine if oracle date is on a weekend?

548

what is index? : Sql dba

553

Why do we use partitions in sql?

538

give the syntax of grant and revoke commands? : Sql dba

607

what does myisamchk do? : Sql dba

552

What is set serveroutput on?

636

What is Collation Sensitivity ? What are the various type ?

493

How is indexing done in search engines?

525

What are primary key and foreign key and how they work?

541

Mention what are the benefits of pl/sql packages?

532

What is the most restrictive isolation level? : Transact sql

548

What does dml mean?

541

what is an alias command? : Sql dba

540

What are the various levels of constraints?

656