Finding duplicate records in the database (duplicate search)

select do, count(*)
from region
group by do
having count(*) > 1;

See also here.