select top 1 emp_name,emp_sal from employee order by emp

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

Question Posted / khushboo

Answer Posted / khushboo

select top 1 emp_name,emp_sal from employee order by emp_sal
desc

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Tell me what are the advantages of using stored procedures?

1020

List out the different types of locks available in sql server?

983

What are wait types?

1127

What is dbcc command in sql server?

1100

What is a print index?

894

How to set database to be read_only in ms sql server?

1017

What does Master database contains?

1144

What is key set driven?

963

Give me any three differences between Truncate and Delete.

1114

How to create a testing table with test data in ms sql server?

1092

Tell me what is de-normalization and what are some of the examples of it?

1056

What is change data capture (cdc) in sql server 2008?

1030

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

1035

What is the tcp/ip port on which sql server runs?

1171

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1037