select top 1 * from (select top 2 * from emp order by sal desc)s order by

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

Question Posted / naresh kumar kalangi

Answer Posted / naresh kumar kalangi

select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal

Is This Answer Correct ?

5 Yes

8 No

Please Help Members By Posting Answers For Below Questions

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

594

what is datawarehouse? : Sql dba

561

How can a pl sql block be executed?

524

How do you remove duplicates without using distinct in sql?

498

Why are cursors used?

574

Can primary key be changed?

522

What are the types of views in sql?

533

What is sql stand for?

571

Can variables be used in sql statements?

548

What is join view in sql?

504

What are character functions?

623

how to calculate expressions with sql statements? : Sql dba

523

State few characteristics of pl/sql?

556

What is sql in oracle?

616

Can we insert data into view?

518