select max(salary) from employee where salary in (select top 4 salary from

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

Question Posted / saber ali

Answer Posted / saber ali

select max(salary) from employee where salary in (select top
4 salary from employee order by salary desc)

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What options are there to delete rows on the publisher and not on the subscriber? : sql server replication

1216

Explain what stored procedure sp_replcounters is used for? : sql server replication

1518

What is the process of indexing?

1009

How to get the definition of a trigger back?

1002

Can you insert NULL in unique column?

1161

Differentiate between a primary key and a unique key.

1071

Can a table be moved to different filegroup?

976

Tell me about joins in database system and explain each in detail.

1047

How to reaname table name without using sp_Rename in sql server..?

996

What is a user-defined function in the sql server and what is its advantage?

1105

What is the native system stored procedure to execute a command against all databases?

1029

Explain the properties of the relational tables?

996

How to read data in a table with "select" statements?

967

how would you store your query in an SSRS report or a Database server?

162

How to execute function in stored procedure sql server?

1154