Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 21955 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / rakhi
Select Salary From [TableNAme] WHERE Salary IN(Select Top
Nth Salary From [TableName] ORDER BY Salary DESC) ORDER BY
DESC
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Do you know what is sql service broker?
How to create a simple user defined function in ms sql server?
What are the default system databases in sql server 2000?
What is reference section?
What are the new features are introduced in sql server 2012 reporting services?
How to delete a database in ms sql server?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
Explain timestamp datatype?
What is a join in sql? What are the types of joins?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
How to create view in stored procedure sql server?
What is difference between global temporary tables and local temporary tables?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
what is an index? : Sql server database administration
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
