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

Explain the collation?

1047

What are statistics?

953

Explain the steps to use transact-sql cursor?

961

What is difference between temp table and cte?

963

How do you delete a trigger?

919

What is a natural primary key?

952

do you know how to configure db2 side of the application? : Sql server database administration

990

What is the difference between for xml raw and for xml auto?

977

Is there any difference between primary key and unique with the not null condition?

888

What do you mean by the term 'normalization'?

1128

Explain microsoft sql server functions?

1036

Tell me what is the stuff and how does it differ from the replace function?

935

Do you know concepts and capabilities of sql server?

1008

Write a sql query to get zero records from a table having n number of records?

1131

How to rebuild master databse?

1032