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,

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

How many null values can be inserted in a coulmn whihc is unique constraint

8 Answers   Flextronics,

---

Can we call procedure in select statement?

0 Answers  

---

How do you handle exceptions. Give the syntax for it?

1 Answers   BCL, Microsoft,

---

---

what is a unique key ? : Sql dba

0 Answers  

---

How delete all data from all tables in sql?

0 Answers  

---

What is clause in sql?

0 Answers  

---

What is Referential Integrity?

3 Answers  

---

What are sql indexes?

0 Answers  

---

What is primary key in db?

0 Answers  

---

what is the main difference between join and subqurey?

3 Answers   Oracle,

---