去除重复数据select t1.* from (selectrow_number() over (partition by subsystem_id order by row_id) r
去除重复数据
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
去除重复数据
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