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 combine two stored procedures in sql?

598

How many types of literals are available in pl sql?

522

define sql insert statement ? : Sql dba

552

How many types of cursors supported in pl/sql?

596

How to run pl/sql statements in sql*plus?

594

What is sqlerrd?

528

What is use of trigger?

515

What is mutating sql table?

613

What type of database is cloud sql?

580

What are the main features of cursor?

631

What is t sql in sql server?

572

Why is stored procedure faster than query?

496

What is a primary key? Explain

547

What is acid property in a database?

588

Why procedure is used in sql?

537