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 row_number() over (partition by subsystem_id order by row_id) rn ,t.* from ad_program t ) t1 where t1.rn=1