select *
  from (select <columns>,
               row_number() over (partition by "это поле" order by "любое поле") rn
          from my_table)
 where rn = 1