For example:
select c1, c2
from mytable
group by c1, c2
having count(*) > 1;
will give only 1 copy each of the duplicates.
For example:
select c1, c2
from mytable
group by c1, c2
having count(*) > 1;
will give only 1 copy each of the duplicates.