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))

How to convert numeric values to integers in ms sql server?

1104

---

What is the difference between cartesian product and cross join?

872

---

What are the character string functions supported by sql server 2005?

1024

---

What is a transact-sql statement batch in ms sql server?

1033

---

What happens if time-only values are provided as date and time literals?

1023

---

What is global temp table?

1007

---

How to declare and use cursor variables?

1186

---

What is xdr?

998

---

Explain what is the difference between union and union all?

1022

---

What is a partitioned view?

1009

---

What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

1078

---

can an automatic recovery be initiated by a user? : Sql server administration

966

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

960

---

How to get the query of a table in sql server?

908

---

What is extended stored procedures?

971

---