How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,

---

what is data control language? : Sql dba

0 Answers  

---

What is the difference between a query and a report?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

---

What are different types of triggers?

0 Answers  

---

How do you update sql?

0 Answers  

---

What is a self join ?

6 Answers   BirlaSoft,

---

What is foreign key in sql with example?

0 Answers  

---

What are pl sql procedures?

0 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

Is primary key a clustered index?

0 Answers  

---