求句SQL,谢谢~
SELECT COUNT(分类), 分类 FROM 表 GROUP BY 分类
分类字段为INT型
如果要把分类1,2归为1 3,4归为2 5,6归为3如上...
怎么用一条语句写出来啊~
[解决办法]
select count(1),case when 分类 in(1,2) then 1 when 分类 in(3,4) then 2 when 分类 in(5,6) then 3 end as 分类
from 表
group by 分类
[解决办法]
SELECT COUNT(*),分类2 FROM
(
SELECT *,case when 分类 in(1,2) then 1 when 分类 in(3,4) then 2 when 分类 in(5,6) then 3 end as 分类2
FROM 表
) t
GROUP BY 分类2
[解决办法]
select sum(floor((分类+1)/2),case when 分类 in(1,2) then 1 when 分类 in(3,4) then 2 when 分类 in(5,6) then 3 end as 分类
from 表
group by 分类
