Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 29 Answers
- 50930 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dev
SELECT * FROM TAB1 A WHERE A.ROWID > ANY
(SELECT B.ROWID FROM TAB2 WHERE A.COL1=B.COL1)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What does rownum mean in sql?
What is data type in sql?
Which sql most popular?
How to make a copy values from one column to another in sql?
Is primary key a clustered index?
What is an exception in pl/sql?
What is sql resultset?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
How long does it take to learn pl sql?
What are reports usually used for?
What is recursive join in sql?
How do you identify a primary key?
How do I copy a table in sql?
Name the different types of indexes in sql and define them.
What is function and procedure?
