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

What is a schema? How is it useful in sql servers?

1116

What is the purpose of primary key?

1018

What is procedure explain with program?

1015

What is use of trigger?

928

What is cte sql?

987

How is data stored in sql?

1058

What is informix sql?

975

Define tables and fields in a database

1126

what are the different functions in sorting an array? : Sql dba

1014

How many tables can a sql database have?

972

What is normalization in a database?

1152

What are the different types of sql commands?

1123

Define sql delete statement.

1007

how to select first 5 records from a table? : Sql dba

975

What is sql stand for?

979