Oracle row_number()移除重複

利用row_number()為重複record編號，然後選取第一筆資料

select [fields], row_number() over (partition by [unique_fields] order by [fields]) as rn from table where rn=1;