Answer Posted / sandeep modapathi

SELECT DISTINCT MIN(SALARY),DEPARTMENT
FROM (SELECT TOP ((SELECT COUNT(DISTINCT DEPARTMENT) FROM
EMPLOYEE)*@N)
SALARY,DEPARTMENT
FROM EMPLOYEE ORDER BY SALARY DESC
) AS CUR1 GROUP BY DEPARTMENT


try it out ..................
it will show you the Nth top salary for each department

What happens if ntwdblib.dll is missing on your machine?

1096

---

What are unicode character string data types in ms sql server?

1137

---

What does the on update no action do?

959

---

Do you know sql server 2008 backup compression?

918

---

What are recommended options to be used while using db mirroring? : sql server database administration

1064

---

What is the difference between push and pull subscription? : sql server replication

1147

---

Explain the cursor lock types?

978

---

You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

839

---

What is a cache in ssrs?

127

---

What is collation sensitivity?

982

---

What it means to be triggered?

908

---

What is the use of sql profiler in sql server 2012?

839

---

What is stretch database in sql server?

1025

---

What is PROJECTION Operation?

959

---

Which rendering formats are affected by the pagesize properties?

134

---