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 monitor replication latency in transactional replication? : sql server replication
How to declare and use cursor variables?
What happens if null values are involved in datetime operations?
What is difference between rownum and rowid?
Are resultset updatable?
Where is trigger in sql server?
What do you understand by intent locks?
Difference between connected and disconnected database in .net with sql server?
What are magic tables in sql server?
How do I view a stored procedure in sql server?
What is the function of inner join?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
what is raid and what are different types of raid configurations? : Sql server database administration
Does hive support indexing?
What is DCL?