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

What does the update command do?

1052

---

What is use of dbcc commands?

1021

---

What is the dbcc command and why is it used?

999

---

What is the difference between inner join and equi join?

926

---

Explain about Normalization?

1015

---

What is trigger and different types of Triggers?

1070

---

How does a profiler work?

873

---

Which language is supported by sql server?

956

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

892

---

What are sql azure firewall rules?

106

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1014

---

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

1068

---

How to use group functions in the select clause in ms sql server?

996

---

Do you know what is blocking?

901

---

What is difference in performance between insert top (n) into table and using top with insert?

973

---