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

What is the distinction amongst delete and truncate?

1071

Explain sql delete command?

1062

Define candidate key, alternate key, and composite key.

928

What is the difference between dbcc indexdefrag and dbcc reindex?

987

How except clause is differs from not in clause?

960

What is the default schema of your login session in ms sql server?

1051

Why it is recommended to avoid referencing a floating point column in the where clause?

971

What is normalization? What number of normalization shapes are there?

1111

How to optimize stored procedures in sql server?

1188

How you can get the list of largest tables in a database?

1022

What is resource governor?

976

You want to implement the one-to-many relationship while designing tables. How would you do it?

962

Explain the working of sql privileges?

1097

What is Federation Root Database?

104

Explain the database you used in your final year project?

1047