Find top Nth employee from each department in terms of
salary?
- 13 Answers
- 22650 Views
- RealPage, I also Faced
- E-Mail Answers
Answer Posted / saurav kumar
select min(salary) from tablename where salary in (select
top N salary from tablename orderby salary desc)
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Explain different types of index?
What are different types of constraints?
in the physical file layout, where should the transaction log be stored in relation to the data file?
What is user-defined inline table-valued function?
What is full outer join in sql server joins?
What are joins in sql and what are the different types of joins?
Explain filestream storage of sql server 2008?
What is data source view or dsv? : sql server analysis services, ssas
How do I uninstall sql server 2014?
What is a view and what are its advantages?
How you can get the list of largest tables in a database?
Can you please explain the difference between primary keys and foreign keys?
What are the advantages of mirroring?
Is a primary key unique?
What is the difference between local and global temporary tables?
