Find top Nth employee from each department in terms of
salary?
Answer Posted / akhil saxena
select e1.sal from emp e1 where
n-1 = (select count(distinct(e2.sal)) from emp e2
where e2.sal<e1.sal)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What do you mean by an execution plan? How would you view it?
Define primary key?
how to trace the traffic hitting a sql server? : Sql server database administration
What is “asynchronous” communication in sql server service broker?
What is the difference between a unique key and primary key?
Explain about thread and memory management process of SQL?
Is it possible in sql table to have more than one foreign key?
What is cross join in sql server joins?
What is sql or structured query language?
What is clustered vs nonclustered index?
What are different types of statements that are supported by sql?
Define the one-to-one relationship while designing tables.
What is the New in SQL server 2008?
Can we install sql server 2016 on windows 7?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration