Answer Posted / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

Explain how you can deploy an SSRS report?

137

---

What stored procedure would you use to view lock information?

905

---

What are the underflow and overflow behaviors on float literals?

1061

---

Difference between report and query parameter.

1026

---

How to move database physical files in ms sql server?

961

---

What are a scheduled jobs or what is a scheduled tasks?

849

---

What is local temp table?

898

---

What are different types of data sources?

937

---

Why it is recommended to avoid referencing a floating point column in the where clause?

922

---

Where to find ntwdblib.dll version 2000.80.194.0?

922

---

What are various ways to enhance the ssrs report?

922

---

How to list all stored procedures in the current database using ms sql server?

1058

---

Difference between group by clause and having clause in SQL?

929

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

893

---

How can we remove orphan records from a table?

933

---