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

What is the synonym of join?

1018

What is data compression? : sql server database administration

1018

Can a rule be bound to any column of any data type?

1025

What is acid properties?

1191

Is INSTEAD OF trigger directly applicable to Table ?

1070

Where sql server usernames and passwords are stored in a sql server?

1038

what's the maximum size of a row? : Sql server database administration

1165

How to delete duplicate rows in sql server?

1156

How do I create a stored procedure in sql server?

1097

Explain an incremental backup?

1052

What is sql server agent and what are the two modes of authentication in sql server?

1112

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

1097

Do you know what is fill factor and pad index?

1047

How to change the name of a database user?

1012

How many cores do I need for sql server 2016?

953