How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

what is the system function to get current user's user id? : Sql server database administration

0 Answers  

---

Can a trigger be created on a view?

0 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What does <> symbol mean?

0 Answers  

---

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

0 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

0 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

---

how can ur insert the emp table

3 Answers   Wipro,

---