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

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1108

What are triggers? How do you invoke a trigger on demand?

1368

What is nonclustered index with included columns ?

1019

Explain “row_number()” in sql server with an example?

1057

Explain cdc and sql injection?

1045

Name and describe few console utilities for ssrs?

288

What are the advantages of user defined function?

1046

Please differentiate between a local and a global temporary table?

1059

What are the types of stored procedures in an sql server?

1038

Can a cursor be updated? If yes, how you can protect which columns are updated?

1179

How will you optimize a stored procedure optimization?

1118

When you use @@error and try-catch?

1099

What are the new data types are introduced in sql 2000?

955

Tell me what is normalization? Explain different forms of normalization?

1075

What is indexed view?

1029