SQL中用Group by 分组 假如有个字段ID,值1~10,想分成3组(1,3,7)(2,4,5,6)(8,9,10)
答案:1 悬赏:60 手机版
解决时间 2021-04-26 23:25
- 提问者网友:焚苦与心
- 2021-04-26 01:28
SQL中用Group by 分组 假如有个字段ID,值1~10,想分成3组(1,3,7)(2,4,5,6)(8,9,10)
最佳答案
- 五星知识达人网友:何以畏孤独
- 2021-04-26 02:17
select id,sum(case when id in (1,3,7) then 1 else 0 end),
sum(case when id in (2,4,5,6) then 1 else 0 end),
sum(case when id in (8,9,10) then 1 else 0 end)
from tb group by id
这个意思?
-----补充-----
select num,sum(case when id in (1,3,7) then num else 0 end),
sum(case when num in (2,4,5,6) then num else 0 end),
sum(case when num in (8,9,10) then num else 0 end)
from tb group by num
试验下这个
sum(case when id in (2,4,5,6) then 1 else 0 end),
sum(case when id in (8,9,10) then 1 else 0 end)
from tb group by id
这个意思?
-----补充-----
select num,sum(case when id in (1,3,7) then num else 0 end),
sum(case when num in (2,4,5,6) then num else 0 end),
sum(case when num in (8,9,10) then num else 0 end)
from tb group by num
试验下这个
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯