Find top Nth employee from each department in terms of
salary?
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
What is table value parameters (tvp)?
What are types of scd? : sql server analysis services, ssas
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to delete exactly duplicate records from a table?
When we should use @@error?
What is the use of for clause?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is page-level compression?
What is clustered vs nonclustered index?
What are different types of subquery?
What are the different types of indexes?
When multiple after triggers are attached to sql table, how to control the order of execution?
What is a database table?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
How you can move data or databases between servers and databases in sql server?