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
- 51911 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
Explain clause in sql?
what are the different type of sql's statements ? : Sql dba
What are transaction and its controls?
What is sql and its types?
What is rename command in sql?
What will you get by the cursor attribute sql%rowcount?
what is primary key? : Sql dba
What is sql indexing?
How to use boolean type in select statement?
What is difference between pls_integer and integer?
What is the difference between joins?
What is java sql drivermanager?
What is the sql query to display the current date?
Why schema is used in sql?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
