SQL CASE可不可以查询多个字段
答案:1 悬赏:30
解决时间 2021-04-21 22:43
- 提问者网友:绿海猖狂
- 2021-04-20 22:12
SQL CASE可不可以查询多个字段
最佳答案
- 二级知识专家网友:放肆的依賴
- 2021-04-20 23:22
种查询SQL, 利用union获bc各自统计结, 再统计整合终结: select sum(d.b_cnt) + sum(d.c_cnt) as total_cnt, sum(d.b_cnt) as b_cnt, case when sum(d.b_cnt) = 0 then '' else d.val end as b_label, sum(d.c_cnt) as c_cnt, case when sum(d.c_cnt) = 0 then '' else d.val end as c_label from( select b as val, count(b) as b_cnt, 0 as c_cnt from A group by b union all select c, 0, count(c) as c_cnt from A group by c ) d group by d.val SQL Serer测试结(栏位序变化), 图" class="ikqb_img_alink"> total_cnt总数, b_labelb栏值, b_cntb栏数, c_labec栏值, c_cntc栏数. 结跟字段否整型关, 统计记录现数.
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯