select * from(select * from Employee order by salary desc) where rowNum<

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

Question Posted / shahid

Answer Posted / shahid

select * from(select * from Employee order by salary desc) where rowNum<3

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I find the size of a sql server database?

878

How to sort query output in descending order in ms sql server?

902

Explain about remote stored procedure?

966

What is the importance of concurrency control?

1177

When I delete any data from a table, does the sql server reduce the size of that table?

959

What is PROJECTION Operation?

962

What is de-normalization in sql database administration? Give examples?

927

How to connect a database with sql express.?

1011

If a stored procedure is taking a table data type, how it looks?

6353

How many triggers you can have on a table?

937

How to set the current database in ms sql server?

1012

Why are sql functions used?

1047

Can you create a logon trigger in sql server 2005 express edition?

1032

What is a data source file?

925

Do you know what is blocking?

901