Answer Posted / usha

SELECT EmpName, Salary
from
(
SELECT EmpName, Salary, Row_Number() OVER(ORDER BY SALARY
DESC) AS 'Salaries'
FROM #Employees
) emp
WHERE Salaries = n

n may be 2,3....

What are the 7 disadvantages to a manual system?

906

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2319

---

What are the benefits and tasks of object explorer? : sql server management studio

1113

---

Tell me about builtinadministrator?

945

---

Write a program to fetch first 10 records from a file?

961

---

Do you know what is openxml in sql server?

1015

---

How do I create a partition table in sql server?

1046

---

What is meant by indexing?

938

---

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

1097

---

What is resource governor?

926

---

What is outer join in sql server joins?

1044

---

What is cached report?

135

---

How to rename an existing column with sql server management studio?

948

---

Can sub report data source be different from that of the parent report?

135

---

What is SQL Azure Federations?

112

---