Answer Posted / neeraj kumar

select top(1) Salary
from(select distinct top(n) Salary
from emp
order by Salary desc ) a
order by Salary




Note-you can find out any position salary through top(n).
n=1,2,3,4,5,6,7,8,9..................

How would we use distinct statement? What is its use?

1078

---

What is a natural primary key?

1057

---

How do I create a trace in sql server?

1052

---

What do you understand by the analysis services in sql server?

949

---

Explain iaas, paas and saas?

90

---

How to Check if table exists in sql server?

1147

---

Which are the olap features?

965

---

What is surrogate key? : sql server analysis services, ssas

1114

---

What is 2nf normalization?

1034

---

Can you import Microsoft Excel data to SSRS?

135

---

How many levels of sp nesting is possible?

1062

---

Difference between uniqe index and uniqe constraint?

988

---

What are different types of join?

1325

---

Explain the concept of view and Types of views in SQL server?

995

---

What is the significance of master, tempdb and model databases?

1084

---