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,

---

What are the different normalization forms?

0 Answers  

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  

---

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

0 Answers  

---

Who developed sql server?

0 Answers  

---

What is normalization? Explain different forms of normalization?

0 Answers  

---

which is best institute to learn sql server in ameerpet or sr nagar or maithrivanam?please help

3 Answers  

---

How do you check sql server is up and running?

0 Answers  

---

What is a view and what are its advantages?

0 Answers  

---

What are the advantages of using cte?

0 Answers  

---

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

---