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
- 51823 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / karthik
i think ths will work!
select * from table_name where rowid in (select max
(rowid) from table_name groupby duplicate_field_name);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the difference between delete and truncate statement in sql?
Can we create foreign key without primary key?
Is join same as left join?
what is the difference between union and union all? : Sql dba
Why function is used in sql?
How to run pl sql program in mysql?
What is the max nvarchar size?
What is the main reason behind using an index?
what is sql server agent? : Sql dba
How would you pass hints to the sql processor?
What is substitution variable?
What does stand for in sql?
What does truncate mean in sql?
How do I run pl sql in sql developer?
What makes a good primary key?
