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
- 47796 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 a primary key? : Sql dba
How do I create a memory optimized filegroup?
how to get a list of columns in an existing table? : Sql dba
Can we rename a column in the output of sql query?
What is difference between sql and oracle?
Why do we need databases?
What is a sql select statement?
Are stored procedures faster than dynamic sql?
What is before and after trigger?
What does inner join mean?
What is sql in oracle?
What is cursor in pl sql with examples?
Does truncate require commit?
What is a procedure in pl sql?
How to use transactions efficiently : transact sql
