oracle distinct多字段去重

--select * from ti_vw_boss结果：

transactionid   dn                     dn_type productid                     src_spid                opt_type   opt_time      state
100000000000011213 158550570010PIBPXXT100118510 0 18-2月 -16 0
100000000000011244 158550570010PIBPXXT100118510 0 18-2月 -16 0

现在要对表数据去重，留下一行，修改如下：

select * from ti_vw_boss where transactionid in (select min(TRANSACTIONID) from ti_vw_boss group by dn,dn_type,productid,src_spid);

结果：

transactionid   dn                     dn_type productid                     src_spid                opt_type   opt_time      state
100000000000011213 158550570010PIBPXXT100118510 0 18-2月 -16 0

满足要求！