Answer Posted / rabi

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

How to define the name and server for a new dsn?

1196

---

How to enter binary string literals in ms sql server?

1212

---

What are the main differences between #temp tables and @table variables and which one is preferred?

1134

---

What is the tcp/ip port on which sql server runs?

1236

---

What are scalar functions?

1051

---

What is a result set object returned by odbc_exec()?

1077

---

What is the sql case statement used for?

1132

---

What is PROJECTION Operation?

1075

---

How to change parameter value inside the report?

169

---

What is the maximum size of column in sql server?

942

---

What are the source of constraints?

978

---

What is user-defined functions? What are the types of user-defined functions that can be created?

1080

---

What is the temp table?

975

---

how you can get the list of largest tables in a database? : Sql server administration

1100

---

Where are stored procedures in sql server?

1124

---