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
- 51669 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
Why is a primary key important?
What is an index in sql with example?
What is equi join in sql?
What is benefit of creating memory optimized table?
Is sqlite free?
What is partition by in sql?
Can triggers stop a dml statement from executing on a table?
What is plpgsql language?
Why do we need sharding?
Explain dml and ddl?
What is having clause in sql?
explain advantages of myisam over innodb? : Sql dba
Can we commit in trigger?
What are the different types of dbmss?
What is sql architecture?
