i think ths will work! select * from table_name where rowid in (select m

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?

Question Posted / karthik

29 Answers
51645 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

Please Help Members By Posting Answers For Below Questions

What operators deal with null?

1097

What is the difference between jpql and sql?

1086

What is sql prepared statement?

976

what is text? : Sql dba

1065

Which sql statement is used to delete data from a database?

952

How do I upgrade sql?

998

what is 'mysqladmin' in mysql? : Sql dba

1019

What is trigger explain it?

1005

Can dml statements be used in pl/sql?

1071

How to get help at the sql prompt?

1108

How do I run a script in sql developer?

941

What is a table partition?

1119

Explain the uses of database trigger.

1105

How do I truncate a sql log file?

1061

How do you concatenate in sql?

1021