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

How will you know when statistics on a table are obsolete?

1034

How do I find the transaction log size in sql server?

917

Difference between Inner vs outer joins?

895

Can a cursor be updated? If yes, how you can protect which columns are updated?

1033

What are the differences between having and where clause.

924

what is a schema in sql server 2005? : Sql server database administration

959

What are the joins in sql server? : sql server database administration

965

Data table as parameter in sql server?

976

Explain important index characteristics?

985

How to perform key word search in tables?

914

What is the report model project?

130

Explain in details security in SQL azure?

121

Explain cross join or cartesian product in sql?

842

what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1910

What is dimension table? : sql server analysis services, ssas

976