select top(1) a.name from ( select top(2) name,salary from employe

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

Question Posted / sandeep

Answer Posted / sandeep

select top(1) a.name
from

(
select top(2) name,salary
from
employee
order by salary desc
)a
order by a.salary asc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is partition in sql query?

1046

What is mutating error in pl sql?

1066

What is sql scripting?

1196

what are date and time functions in mysql? : Sql dba

1028

How do you explain an index number?

1188

How sql query is executed?

1187

What is range partitioning?

1014

What is the use of index in sql?

1068

what is sql? : Sql dba

1071

explain about mysql and its features. : Sql dba

1053

How do I partition in sql?

1023

Is sql low level language?

1066

What is sql comments?

1119

Is microsoft sql free?

1142

How do I create an index in word?

1076