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 are the steps to insert a table?

948

Can you please explain the difference between function and stored procedure?

1014

how to overcome kernel isssues

1629

How to use "if ... Else if ... Else ..." Statement structures in ms sql server?

1085

What is update locks?

895

What structure can you implement for the database to speed up table reads?

1204

What is "scheduled jobs" or "scheduled tasks"?

984

What is dbcc command in sql server?

1097

Describe in brief authentication modes in sql server.

1034

What are the advantages of mirroring?

995

What number sorts of privileges are accessible in sql?

1038

What is a dbms wizard?

1027

Different types of keys in SQL?

1103

Which are the two editions in which SQL Azure database available?

119

Explain the ways to controlling cursor behavior?

923