Answer Posted / rabi

SELECT A.SAL
FROM TABLE A WHERE &N=(SELECT COUNT(DISTINCT(B.SAL))
WHERE A.SAL<=B.SAL);

How to return the top 5 rows from a select query in ms sql server?

1089

---

What is the purpose of update statistics and scope_identity() function?

1061

---

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

1153

---

Explain what are partitioned views and distributed partitioned views?

901

---

What is the maximum length of an alert name?

969

---

What do you know about system database? : SQL Server Architecture

944

---

What is the web service used for reporting services?

116

---

how many clustered indexes can be created on a table? : Sql server database administration

1085

---

Tell me what are cursors and when they are useful?

919

---

What is the difference between index seek vs. Index scan?

982

---

Is truncate a dml command?

897

---

What is sql stored procedure?

1029

---

What is bookmark link in ssrs?

234

---

Can a trigger be created on a view?

906

---

What is the use of =,==,=== operators?

966

---