select min(salary) from tablename where salary in (select top N salary fr

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

Question Posted / saurav kumar

Answer Posted / saurav kumar

select min(salary) from tablename where salary in (select
top N salary from tablename orderby salary desc)

Is This Answer Correct ?

6 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is a fan-out query in SQL Azure?

123

How to delete a database in ms sql server?

1325

Define model database?

1034

Tell me about joins in database system and explain each in detail.

1112

Explain few examples of stored procedure over triggers?

1122

What is the difference between a function and a trigger?

1128

What is transaction server isolation?

1095

What is partition index in sql server?

1176

Who is the owner of a schema in ms sql server?

1120

Does partitioning help performance?

997

How will you make an attribute not process? : sql server analysis services, ssas

1160

Do I need a report server to run reports in my application?

170

What is a select query statement in ms sql server?

1132

How and why use sql server?

1063

What do you mean by SQL injection attack?

1129