Find top Nth employee from each department in terms of
salary?
Answer Posted / pradeep nambiar
select distinct(a.salary) from employee a where &n=(select
count(distinct(b.salary)) from employee b where
a.salary=b.salary)
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Which is the latest version of sql server and when it is released?
what is the primary use of the model database? : Sql server administration
What are the advantages of the mirroring?
your distribution database is full what will u do
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Write the queries for commands like Create Table, Delete table, Drop Table etc.
how to use DTS package in 2000,2005,2008 in sql server
How to create a view using data from another view?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Why use triggers?
How to check status of stored procedure in sql server?
What is a transact-sql statement?
Can we use having clause without group by?
What is the purpose of the model database?
How to add the custom code in Report?