select t.a1,t.a2,t.a4 from (select a1,a2,a3,a4, row_number() over (partition by a2,a3 order by a1 asc) as num from a) t where num >1;
select t.a1,t.a2,t.a4 from (select a1,a2,a3,a4, row_number() over (partition by a2,a3 order by a1 asc) as num from a) t where num >1;