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 is purpose of normalization?

950

What is the meaning of sql server?

986

Can we update data in a view?

1034

Explain the database you used in your final year project?

1045

What is dirty page?

973

Tell me what is fill factor?

964

Explain Geometry datatype in sql server 2008 with example

991

How to set database to be single_user in ms sql server?

1030

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1010

How to check if stored procedure is running in sql server?

1062

How to use subqueries in the from clause in ms sql server?

1164

Can we use trigger new in before insert?

922

What is normalization 1nf 2nf 3nf?

1060

What stored by the model?

1060

How you provide security to cube? : sql server analysis services, ssas

965