Suppose multiple column with 1000 records in a table, how to find the duplicate record in whole table?

Question

Please help.

Are you using MySQL or Oracle? Don't tag products not involved. — jarlh, Mar 21 '17 at 11:19

score 1 · Answer 1 · edited May 23 '17 at 12:00

1

Duplicated id's:

select s.id, t.* 
from [stuff] s
join (
    select name, city, count(*) as qty
    from [stuff]
    group by name, city
    having count(*) > 1
) t on s.name = t.name and s.city = t.city

answer is also posted in this topic: How do I find duplicates across multiple columns?

edited May 23 '17 at 12:00

Community

1
1

answered Mar 21 '17 at 11:20

Pieter Meulemeester

11
3

Suppose multiple column with 1000 records in a table, how to find the duplicate record in whole table?

1 Answers1