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.

Explain the categories of stored procedure?

940

---

What is use of except clause?

1096

---

What is constraints and its types?

957

---

what is an index? : Sql server database administration

990

---

How to connect a database with sql express.?

1071

---

In which files does sql server actually store data?

912

---

What do you mean by subquery?

1094

---

How do you send email on SQL Server?

1069

---

List all the types of user-defined functions?

1110

---

What is the difference between for trigger and after trigger?

1118

---

How to Sync Two SQL Azure Databases?

121

---

What do you understand by a view? What does the with check option clause for a view do?

1011

---

Can you roll back the ddl statement in a trigger?

989

---

What you can do to delete a table without the delete trigger firing?

978

---

Explain for xml explicit mode?

981

---