Answer Posted / anand patel.

It is a very generic and easy way to find the Nth higest
salary with there employee/s name.

select * from emp where salary =
(select max(salary) from emp where salary in
(select top (select (count(*)-(n-1))from emp) salary
from emp order by salary))

What do you mean by authentication modes in sql server?

1136

---

Sql server reporting services vs. Crystal reports.

140

---

What is difference between rownum and row_number?

1025

---

How many types of schemas are there?

1094

---

How can i Relate Tables in SSIS

1135

---

Explain sub-query?

1014

---

Please differentiate between a local and a global temporary table?

1059

---

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

1015

---

Where are sql server usernames and passwords stored in the sql server?

1176

---

What do you mean by table and field in sql?

1066

---

what is difference between NULL and ISNULL in SQL Server 2008?

1058

---

Explain how many normalization forms?

1077

---

What is forward - only cursors / read only cursor?

1134

---

What does REVERT do in SQL Server 2005?

1013

---

What is the maximum size per database for sql server express?

1103

---