gistfile1.sql

with v as (
  select * from (
    select 
      id, hoge, huga,
      row_number() over(partition by hoge, fufa order by id) as rownum
    from T
  ) vv
  where
    vv.rownum > 1
)
select * from T a
where
  a.id not in (
    select vv.id from vv
  )