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 the order in which the sql query is executed?

882

Can we use where and having clause together?

981

What is the optimization being performed in oracle and SQL Server?

999

What is the purpose of floor function?

978

What is sub-query in sql server?

1142

Mention what are the core components of ssrs?

296

What is difference between clustered and non clustered index?

923

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

936

What do you mean by tablesample?

1035

What is a trigger what are the advantages of trigger?

917

How can you find out how many rows returned in a cursor?

971

what type of index will get created after executing the above statement? : Sql server database administration

922

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1082

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1014

What do mean by xml datatype?

1009