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

Which joins are sql server default?

1013

What is difference between Datepart() and Datename() in SqlServer?

1206

How to create a user to access a database in ms sql server using "create user" statements?

954

How to create and drop temp table in sql server?

1052

What is a database in ms sql server?

1058

What is a not null constraint?

1034

How to Update from select query in sql server?

1062

How to create an identity column?

1222

what is database replication? : Sql server database administration

1066

How to create an index on an existing table in ms sql server?

981

What do you mean by the term 'normalization'?

1209

Explain full-text query in sql server?

1009

What is the use of =,==,=== operators?

1013

Write an sql query to find first weekday of the month?

920

What happens if an integer is too big for int date type?

978