Answer Posted / neeraj kumar

select top(1) salary from(
select distinct nth salary
from emp
order by salary desc)a
order by salary



In this answer you can put any position in place of nth then you find the salary.
If you are satisfied this answer then reply me please.

how to use DTS package in 2000,2005,2008 in sql server

1904

---

How do you implement session management in SQL Server mode?

1159

---

how you can deploy an ssrs report?

185

---

What is difference between materialized view and view?

954

---

explain the storage models of olap? : Sql server database administration

1016

---

How many triggers you can have on a table?

1035

---

How to find tables without indexes?

1156

---

Explain mixed authentication mode of sql server?

1120

---

What is the recovery model?

1061

---

How many levels of sp nesting is possible?

1101

---

How do I shrink an ldf file?

1040

---

What is log ldf?

1047

---

Explain what are page splits? : SQL Server Architecture

1122

---

How to optimize stored procedure optimization?

968

---

What is the command dbcc checkdb used for?

1074

---