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 ddl and dml commands?

845

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1127

What is a ddl statement?

851

Do you know clustered and non-clustered index?

929

What does indexation mean?

916

Explain about protocol layer present in SQL server?

1100

What is difference between order by and group by?

953

What is difference between createstatement and preparedstatement?

1020

what are the critical issues you have resloved in your company

1920

How to use clusters?

881

How ssrs maintain security?

1015

Ms sql server index?

1008

How to start sql server browser service?

1065

What is the difference between clustered and non-clustered indexes in ms sql server?

932

How to get a list of columns in a view using the "sp_columns" stored procedure?

984