select top 1 salary,employee from (table name) group by department

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

Question Posted / madhu

Answer Posted / madhu

select top 1 salary,employee from (table name) group by
department

Is This Answer Correct ?

10 Yes

13 No

Please Help Members By Posting Answers For Below Questions

What are the indexes in sql server?

1117

How to loop through result set objects using odbc_fetch_row()?

981

What are different types of raid levels?

1171

Which tcp/ip port does the sql server run on? How can it be changed?

1056

Does order by actually change the order of the data in the tables or does it just change the output?

1150

How to join two tables in a single query in ms sql server?

996

How to get the number of affected rows?

1007

What is the command to change the recovery model?

1048

What is a recursive stored procedure in sql server?

1179

What is bcnf normalization form?

1120

What are sub reports?

203

Explain trigger classes i.e. Instead of and after trigger?

883

What does it mean to manipulate data?

1002

Can I use sql azure as a backup with log shipping or database mirroring?

156

Write a code to select distinct records without using the DISTINCT keyword.

1117