select Top 1 salary from ( select top 2 salary from emp

write the query for find the top 2 highest salary in sql
server

Question Posted / santosh kumar

Answer Posted / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
desc.

Is This Answer Correct ?

13 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Why do we use functions?

857

Explain sub-query?

902

How many types of dimensions are there and what are they? : sql server analysis services, ssas

1029

What is the difference between web edition and business edition?

111

What are the rules to use the rowguidcol property to define a globally unique identifier column?

966

List the types of recovery model available in sql server?

873

What is acid db?

841

What is the importance of three tier architecture?

1027

How do you run a trace?

850

What is the need for indexing?

889

How to assign null values to variables or columns?

915

Explain the steps needed to create a scheduled job?

886

Can binary strings be used in arithmetical operations?

887

Can group by be used without aggregate functions?

857

Explain what is the main purpose of having conversation group?

882