중복데이터 업데이트

update RS_BUDGET
set division='P'
where RS_BUDGETID IN (
select RS_BUDGETID from
(
    select
    ROW_NUMBER() OVER (PARTITION BY SITEID..
    order by SITEID.. ) cnt, RS_BUDGETID
    from RS_BUDGET
) where cnt = 2
)