select min(salary) from tablename where salary is(select top n salary fro

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

Question Posted / ricky

Answer Posted / ricky

select min(salary) from tablename where salary is(select
top n salary from tablename order by salary desc)

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How self join is different from outer join?

1121

Tell me what is use of except clause? How it differs from not in clause?

962

What is the openxml statement in sql server?

1075

Can you pass expressions to function parameters?

1103

Explain the phases a transaction has to undergo?

1057

How to use union to merge outputs from two queries together in ms sql server?

1069

What is the new security features added in sql server 2016? : sql server security

1116

What is code near application topology?

279

What is 5nf in normalization form?

994

List the advantages of using stored procedures?

1056

Can group by be used without aggregate functions?

924

Can we add an identity column to decimal datatype?

1002

Explain where clause?

989

What is shared lock?

904

Why do we use non clustered index?

1083