---

select
    a.id,
    a.code_1c,
    a.code,
    a.last_name,
    a.first_name,
    a.middle_name,
    a.entity_id,
    a.fund_branch_id,
    a.partner_id,
    a.sales_office_id,
    a.deactivate_date,
    a.deactivate_reason
from ourpension.agent a
where a.code_1c in (
    select a2.code_1c
    from ourpension.agent a2
    where a2.code_1c is not null
      and btrim(a2.code_1c) <> ''
    group by a2.code_1c
    having count(*) > 1
)
order by a.code_1c, a.id;