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 / chandan kumar

Answer Posted / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is nonclustered index with included columns ?

973

Tell me about builtinadministrator?

1007

What is b tree index?

921

Explain error handling in ssis?

1038

How do I find sql server instance name?

968

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

961

explain databases and sql server databases architecture? : Sql server database administration

971

Can you name some of the dml commands in sql?

1040

If user is owning any SQL Objects, can we drop that user

2086

Can the “if update (colname)” statement be used in a delete trigger?

1000

What is logon trigger?

1106

How to connect sql server management studio express to sql server 2005 express?

1050

Explain the flow of creating a cube? : sql server analysis services, ssas

1062

What are commonly used mssql functions in php?

1088

List out the differences between global and local temp tables in sql server?

1070