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 is 3nf normalization form?

1172

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1321

Define normalisation?

1155

How to run sql server 2005 books online on your local system?

1006

What are the steps you must follow to hide sql server instances?

1033

How to remove duplicate rows from table?

1316

What is difference between createstatement and preparedstatement?

1176

Explain aggregate functions?

1143

What is raid, and how it can influence database performance?

1102

what is the primary use of the model database? : Sql server administration

1100

Can you use order by when defining a view?

1022

You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?

995

Does a server store data?

958

What is a primary key?

1000

Which tcl commands are available on the sql server?

1143