Answer Posted / suhail qaiser

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

What is the concept of optimization?

1060

---

How to delete multiple rows with one delete statement in ms sql server?

1027

---

What is proper subset of candidate key?

998

---

What is the Control Flow in SSIS

1094

---

What are different types of statements that are supported by sql?

1047

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1140

---

Can primary key be a foreign key?

1060

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1050

---

When cursors are useful?

1107

---

What is onf in normalization form?

1059

---

What is PROJECTION Operation?

1026

---

How to list all schemas in a database?

1064

---

What happens if you add a new index to large table?

942

---

How do I partition a table in sql server?

1047

---

What Is Rdbms?

1163

---