select case when aa in(1,3,4) then 1 else aa),count(*) from table group by case when aa in(1,3,4) then 1 else aa)
Select (case when aa in (1,3) then 1 when aa in (2,4) then 2 else aa end) as aa,count(*) from table where bb = 'c' group by (case when aa in (1,3) then 1 when aa in (2,4) then 2 else aa end)
from table
where bb = 'c'
group by
(case when aa in (1,3) then 1 else aa end)
aa里有记录1,2,3,4
要求如果在记录aa里1或3,2和4则数量统计在一起应该怎样写呢?
from table
where bb = 'c'
group by
(case when aa in (1,3) then 1 when aa in (2,4) then 2 else aa end)