Answer Posted / ashish

hey u can try This It defenately work...It for The nth
position mean for the N th node try it out.......



SELECT *
FROM emp A
WHERE (n-1) = (
SELECT COUNT(DISTINCT(B.salary))
FROM emp B
WHERE B.salary > A.salary)

Mention the differences between local and global temporary tables.

1110

---

Explain difference between cross join and full outer join?

1065

---

What is the difference between Stored Procedures and triggers?

1133

---

What is 2nf example?

1052

---

How is SQL Azure different than SQL server?

225

---

What is difference between equi join and inner join?

1038

---

Define the one-to-one relationship while designing tables.

939

---

What is a system database and what is a user database?

1138

---

What is the recovery model? List the types of recovery model available in sql server?

944

---

Explain collation?

1100

---

What is a partition function in sql server?

1216

---

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1228

---

What are the different types of subquery?

1200

---

How can you ensure that the database and sql server based application perform well?

1123

---

Is it possible to replicate data from sql server to oracle? : sql server replication

1140

---