Answer Posted / roshan

select employeeid, employeeName ,Salary from table1 where
Salary =(select min(a.Salary) from table1 inner join
(select top 2 Salary from table1
order by Salary desc) a on table1.Salary = a.Salary)

if we change the top value we will get the n'th largest
salary

What are triggers in ms sql server?

1105

---

What is trigger explain with program?

934

---

how many clustered indexes can be created on a table? : Sql server database administration

1068

---

Can a rule be bound to any column of any data type?

913

---

How will you decide the active and passive nodes?

1074

---

What are advantages of ssrs or why we should use ssrs?

129

---

How to return the second 5 rows in ms sql server?

1006

---

Is mysql better than sql server?

1005

---

Explain the difference between clustered and non-clustered index?

872

---

What is the distinction amongst delete and truncate?

1003

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1016

---

Differentiate between a primary key and a unique key.

1001

---

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

990

---

What is updatable resultset?

938

---

What are the two authentication modes in sql server?

1062

---