select e1.sal from emp e1 where n-1 = (select count(distinct(e2.sal)) fro

Find top Nth employee from each department in terms of
salary?

Question Posted / akhil saxena

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

Please Help Members By Posting Answers For Below Questions

What do you mean by an execution plan? How would you view it?

874

Define primary key?

1081

how to trace the traffic hitting a sql server? : Sql server database administration

1776

What is “asynchronous” communication in sql server service broker?

963

What is the difference between a unique key and primary key?

899

Explain about thread and memory management process of SQL?

925

Is it possible in sql table to have more than one foreign key?

980

What is cross join in sql server joins?

1077

What is sql or structured query language?

1089

What is clustered vs nonclustered index?

888

What are different types of statements that are supported by sql?

987

Define the one-to-one relationship while designing tables.

859

What is the New in SQL server 2008?

922

Can we install sql server 2016 on windows 7?

1075

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1069