Find top Nth employee from each department in terms of
salary?
Answer Posted / saber ali
select max(salary) from employee where salary in (select top
4 salary from employee order by salary desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How will you know when statistics on a table are obsolete?
How do I find the transaction log size in sql server?
Difference between Inner vs outer joins?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What are the differences between having and where clause.
what is a schema in sql server 2005? : Sql server database administration
What are the joins in sql server? : sql server database administration
Data table as parameter in sql server?
Explain important index characteristics?
How to perform key word search in tables?
What is the report model project?
Explain in details security in SQL azure?
Explain cross join or cartesian product in sql?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is dimension table? : sql server analysis services, ssas