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?
- 28 Answers
- 47451 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 does myisamchk do? : Sql dba
Why do we go for stored procedures?
What is #table in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
What does the hierarchical profiler does?
how to get help information from the server? : Sql dba
What is t sql used for?
What is the syntax and use of the coalesce function?
What is the difference between view and stored procedure?
Explain the rollback statement?
What is the maximum database size for sql express?
How many columns should be in an index?
What is sql key?
How to read xml file in oracle pl sql?
Why is theta join required?
