I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?

2 Answers  

---

You want to implement the many-to-many relationship while designing tables. How would you do it?

0 Answers  

---

What is equi join with example?

0 Answers  

---

Where do you find the default Index fill factor and how to change it?

0 Answers  

---

How to test subquery results with the exists operator?

0 Answers  

---

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

---

Can primary key be a foreign key?

0 Answers  

---

What different steps will a sql server developer take to secure sql server?

0 Answers  

---

how to find the particular row in table?(means suppose one table contain 10 rows , in these 10 rows how to find the particular row(example in 10 rows i want 5 row how)?

16 Answers   Accenture, IBM, Marlabs,

---

What the different components in replication and what is their use?

0 Answers  

---

What is the difference between in and exists. Ex: select * from emp where empno in(....) and select * from emp where empno exists(....) What is the difference between a Join and Union and Union and UnionAll.

5 Answers   ABC, Accenture,

---