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

Define concurrency control. : Transact sql

1195

How do I turn a list into a table?

969

What is optimistic concurrency control? : Transact sql

989

What is cursor explain with example?

992

What information is needed to connect sql*plus an oracle server?

1034

What is scope of pl sql developer in future?

1028

what happens when the column is set to auto increment and you reach the maximum value for that table? : Sql dba

1043

Can I create table without primary key?

1004

Where the sql database files are stored?

1025

Is time a data type in sql?

915

what is timestamp in mysql? : Sql dba

1084

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1074

What are the types of records?

998

How many aggregate functions are available there in sql?

988

how many groups of data types? : Sql dba

1033