Find duplicates based on multiple columns

duplicates.sql

select s.id, t.* 
from service_groups s
join (
    select short_name, service_id, count(*) as qty
    from service_groups
    group by short_name, service_id
    having count(*) > 1
) t on s.short_name = t.short_name and s.service_id = t.service_id;