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
- 50884 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / mohan
select count(*),column_name from table_name group by
column_name having count(*)>1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the different between now() and current_date()? : Sql dba
Difference between truncate, delete and drop commands?
What is scope and visibility in PL/SQL?
What is delete command in sql?
When can we use the where clause and the having clause?
What are keys in sql?
How to get each name only once from an employee table?
what are the 'mysql' command line arguments? : Sql dba
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
what is table? : Sql dba
What does data normalization mean?
Name some usages of database trigger?
What is before and after trigger?
What does 0 mean in sql?
Can we insert in sql function?
