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

Can a function call a stored procedure in sql server?

967

---

What are entities and relationships?

979

---

Is the primary key column of a table an index in ms sql server?

966

---

When would you use the stored procedures or functions?

1008

---

what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration

990

---

What extended events?

1012

---

What is the difference between online clustering and Offline clustering?

2421

---

What happens if you delete a table that is used by a view?

995

---

How to create database with physical files specified in ms sql server?

1005

---

What do you mean by an execution plan?

1122

---

What is trigger and different types of Triggers?

1154

---

What is the order in which the sql query is executed?

946

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

1910

---

Can you name some of the dml commands in sql?

1040

---

What happens if null values are involved in bitwise operations?

1039

---