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 restrictions applicable while creating views? : SQL Server Architecture

981

How to include date and time values in sql statements?

1047

Write the SQL query to drop, truncate and delete table.

917

what are triggers? : Sql server database administration

865

Explain the use of keyword with encryption. Create a store procedure with encryption?

898

What are the differences between decimal and float in ms sql server?

1122

What is equi join with example?

1015

How ssrs maintain security?

1018

What is the architecture of ms sql reporting service?

925

What are the disadvantages of indexes?

998

How to test values returned by a subquery with the in operator?

1135

What are a database and a data warehouse?

972

What is bit data type?

980

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

907

What are trace flags and mention a few common trace flags used with sql server?

1039