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 difference between cursor and trigger?

1070

What is a temporal data type?

1045

What are the different parts of a package?

1113

What is an emotional trigger?

1003

What are the packages in pl sql?

1009

How to add, remove, modify users using sql?

1032

Why do we use partitions in sql?

1043

When should I use nosql database?

1006

Is inner join faster than left join?

1188

Explain the components of sql?

1056

What is the most restrictive isolation level? : Transact sql

1083

What are the different sql languages?

1033

Is sql a dbms?

996

Is left join and outer join same?

1054

Is sql similar to python?

969