select * from (select ID,Salary from employee order by Salary desc) wher

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

Question Posted / kapil singh chauhan

Answer Posted / kapil singh chauhan

select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3

Is This Answer Correct ?

4 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is query and its types?

923

What is autocommit mode in sql server?

1190

What is the purpose of sql profiler in sql server?

1030

What is the difference between osql and query analyzer?

1006

What is the maximum rows in sql server table?

922

Explain subquery and state its properties?

1053

What are the pre-defined functions in the sql server?

1124

What is the optimization being performed in oracle and SQL Server?

1060

Explain how many normalization forms?

1038

how to invoke a trigger on demand? : Sql server database administration

1091

What are the advantages to use stored procedures?

1119

explain different types of constraints? : Sql server database administration

962

Explain microsoft sql server functions?

1122

How do I determine how many instances of sql server are installed on a computer?

1012

What is wrong with sql server client libarary dll, ntwdblib.dll?

1050