5,891
社区成员




select a,b,sum(c),case when d in (1,2,3,4,5) then 1 when d in (0,6,7,8) then 2 end
from
(select a,b,c,d dtest1 union all
select a,b,c,d from test2
union all
select a,b,c,d from test3)
group by
a,b,case when d in (1,2,3,4,5) then 1 when d in (0,6,7,8) then 2 end;
select a,b,sum(c),d
from
(select a,b,c,case when d in (1,2,3,4,5) then 1 when d in (0,6,7,8) then 2 end d dtest1
union all
select a,b,c,case when d in (1,2,3,4,5) then 1 when d in (0,6,7,8) then 2 end d from test2
union all
select a,b,c,case when d in (1,2,3,4,5) then 1 when d in (0,6,7,8) then 2 end d from test3)
group by
a,b,d;