sql筛选 oracle

Question

我想按照如下思路进行筛选：

   TO_ID如果有重复，那么筛选出ACK为1的数据

 

Answer 1

select * from (select *,row_number() over(partition by TO_ID ORDER BY ACK DESC ) as rk from 表) t where rk=1;