How to SELECT all occurrences of all duplicate rows with all columns from a table?

Viewed 1280

For example:

select c1, c2
from mytable
group by c1, c2
having count(*) > 1;

will give only 1 copy each of the duplicates.

3 Answers
Related