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

Can we add our custom code in ssis?

994

---

How can we get count of the number of records in a table?

957

---

When columns are added to existing tables, what do they initially contain?

1037

---

What are filegroups in sql server?

1067

---

What are the three different part of rdl file explain them?

269

---

Difference between primary key and clustered index?

1014

---

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1009

---

What is update locks?

895

---

What are the advantages of policy management?

997

---

What is buffer cash and log cache in sql server?

1130

---

How to backup SQL Server Reporting Services ?

150

---

What is the difference between NOROW and LOCKROW?

2844

---

How to create median function?

166

---

Explain the properties of a relational table?

1027

---

Do you think BCNF is better than 2NF & 3NF? Why?

1279

---