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
- 52632 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 dialect in sql?
What are different sql data types?
What are the different parts of a package?
What is full join?
What is before and after trigger?
How many rows can sqlite handle?
explain the difference between myisam static and myisam dynamic. : Sql dba
Why do we need pl sql?
What is a database trigger?
What is a natural join?
How many types of normalization are there?
What are sql built in functions?
What is memory optimized?
how can we repair a mysql table? : Sql dba
Can we rename a column in the output of sql query?
