Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 22653 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / madhu
select top 1 salary,employee from (table name) group by
department
| Is This Answer Correct ? | 10 Yes | 13 No |
Post New Answer View All Answers
What is difference between joins and subqueries?
Which Model uses the SET concept
What to check if a User database is locked?
What is the difference in accessing db between sql server vs sql azure?
What is sqlcmd?
What is data source document?
Define right outer join in sql server joins?
What the different types of Replication and why are they used?
Which are ddl commands?
What are the differences between substr and charindex in sql server.
What is raid and what are different types of raid levels?
what is an index? : Sql server database administration
What happens when transaction log is full?
What is executereader?
What are three major types of constraints?
