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?
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 is sql architecture?
What is nvarchar max in sql?
What is trigger in sql and its types?
What is view explain with example?
explain the delete statements in sql
who introduced sql?
what are the nonstandard string types? : Sql dba
Explain lock escalation? : Transact sql
How does index help in query performance?
How to create a menu in sqlplus or pl/sql?
how to delete an existing column in a table? : Sql dba
What is sql basics?
How do you bind variables in pl sql?
What is a constraint? Tell me about its various levels.
what does the t-sql command ident_current does? : Transact sql