去除重复数据 select t1.* from (select row_number() over (partition by subsystem_id order by row_id) rn ,t.* from ad_program t ) t1 where t1.rn=1
