Answer Posted / aravinda

try with this query you will get desired position salary.


Select Salary From Employees a Where 1=(
Select Count(Distinct Salary) From Employees b
Where a.Salary <= b.Salary );

just replace where clause number for desired position. ,2,3,4

Explain transaction server isolation?

1085

---

How do I create a trace in sql server?

1092

---

where the connection string store in the database

2124

---

What is the default value of an integer data type in sql server 2005?

998

---

what are isolation levels? : Sql server database administration

1061

---

What is service broker?

1063

---

What is a dataset and what are the different types of datasets?

141

---

What is encryption key?

138

---

What is store procedure?

1117

---

What are the aggregate and scalar functions?

1137

---

What happens if null values are involved in boolean operations?

1047

---

Why would you call update statistics?

1076

---

Do you know query execution plan?

1267

---

What are trace files?

1005

---

What purpose does the model database server?

1148

---