write the query for find the top 2 highest salary in sql
server
Answer Posted / shahid
select * from(select * from Employee order by salary desc) where rowNum<3
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is the distinction amongst delete and truncate?
Explain sql delete command?
Define candidate key, alternate key, and composite key.
What is the difference between dbcc indexdefrag and dbcc reindex?
How except clause is differs from not in clause?
What is the default schema of your login session in ms sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
What is normalization? What number of normalization shapes are there?
How to optimize stored procedures in sql server?
How you can get the list of largest tables in a database?
What is resource governor?
You want to implement the one-to-many relationship while designing tables. How would you do it?
Explain the working of sql privileges?
What is Federation Root Database?
Explain the database you used in your final year project?