Simple duplicate deletion by unique col

delete_duplicates.sql

delete from reg.cropio_export exp
where exp.obj in ('machine', 'trailer')
and exp.objectid not in (
        select max(objectid) as objectid
        from reg.cropio_export
        where obj in ('machine', 'trailer')
        group by obj, uid
)
;