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

Explain the purpose of indexes?

1025

Can we create clustered index on composite key?

1176

What is the difference between delete and truncate statements?

1131

How many servers can we create in a single subscription?

162

Explain different types of Normalization.

1908

Do you know the different ddl commands in sql?

1109

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

990

When would you use sql joins?

1030

How many types of objects are there?

1077

What is constraints and its types?

1001

What are the methods used to protect against sql injection attack?

1121

What Is Rdbms?

1241

What are the differences between substr and charindex in sql server.

1193

what is a join? : Sql server database administration

1331

How to provide default values to function parameters?

1225