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 restore performance issues and how to check?

1950

---

How to create a new table in a given schema?

1114

---

What is the return type of executeupdate ()?

859

---

What is sql or structured query language?

1088

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

895

---

What is correlated subquery in sql server?

1019

---

Do you know sql server 2008 introduces automatic auditing?

915

---

What does top operator do?

965

---

What is a unique index?

887

---

How you can minimize the deadlock situation?

983

---

How do database indexes work?

956

---

What is encryption key?

117

---

What is the command used to recompile the stored procedure at run time?

1018

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

889

---

What are the recovery models for a database?

1058

---