Select Salary From [TableNAme] WHERE Salary IN(Select Top Nth Salary From

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

Question Posted / rakhi

Answer Posted / rakhi

Select Salary From [TableNAme] WHERE Salary IN(Select Top
Nth Salary From [TableName] ORDER BY Salary DESC) ORDER BY
DESC

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How and why use sql server?

955

What is data set in report?

121

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

1062

Explain the etl (extraction, transformation, and loading)?

940

Can you explain what is the use of custom fields in report?

1002

Can group functions be mixed with non-group selection fields in ms sql server?

892

How to create a stored procedure with a statement block in ms sql server?

990

What is #table in sql server?

1001

What is a full text index?

871

What are different types of table joins?

964

What do you mean by data manipulation language?

950

What is a scheduled job or what is a scheduled task?

915

What are the differences between DDL, DML and DCL in SQL?

1171

Explain about Joins?

938

How do I start sql server?

926