Answer Posted / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

How to delete a database in ms sql server?

563

---

Explain what are magic tables in sql server?

538

---

What is difference between standardization and normalization?

532

---

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

545

---

What is dbcc?

735

---

---

What is the Difference Between Primary and Foreign Key?

587

---

How do use Having,Group by,Group function in SQL?

1358

---

Can you explain different types of joins?

547

---

What are the different types of sql server replication? : sql server replication

624

---

How to enter comments in transact-sql statements?

553

---

What is indexing a document?

555

---

What are the difference between data mart and data warehouse? : sql server analysis services, ssas

500

---

Explain the third normal form(3nf)?

523

---

Tell me the phases a transaction has to undergo?

550

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

5772

---