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
- 47234 Views
- Alps, Aricent, Bank Of America, Wipro, I also Faced
- E-Mail Answers
Answer Posted / cesar di sanctis
select * from <table_name>
where <column_name> in
(select <column_name>
from <table_name>
group by <column_name>
having count(*) > 1)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Why is sql better than hql?
who introduced sql?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is cross join sql?
What are the possible values for the boolean data field?
What are the three forms of normalization?
What is ttitle and btitle?
How do I edit a stored procedure?
What is a schema? How is it useful in sql servers?
Is sqlite thread safe?
how to create a new table in mysql? : Sql dba
Is sql a backend?
Is sql a case sensitive language?
What is snowflake sql?
