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..................

What is the difference between value type and reference type?

872

---

What are basics of policy management?

1053

---

How display code or Text of Stored Procedure using Sql query in Sql Server ?

1073

---

What is the syntax to execute the sys.dm_db_missing_index_details?

971

---

What is the default Port No on which SQL Server listens?

1071

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1089

---

What sql server means?

913

---

If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

935

---

We need to perform what steps in the following order to work with a cursor?

1171

---

Why Master database is required?

1060

---

how to create “alternate row colour”?

144

---

How do I start sql server?

928

---

List down some advantages of sql stored procedure?

910

---

How to enter binary string literals in ms sql server?

1099

---

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

886

---