mysql sql根据某个字段的不同条件计算和

最新推荐文章于 2024-12-23 14:30:59 发布

palma_he

最新推荐文章于 2024-12-23 14:30:59 发布

阅读量2.2k

点赞数 1

分类专栏： mysql 文章标签： mysql

本文链接：https://blog.csdn.net/palma_hezhengjie/article/details/108830301

版权

mysql 专栏收录该内容

6 篇文章

订阅专栏

$check_info = $checkModel->field('
sum(case when typeId=1 then 1 else 0 end) as zc,
sum(case when typeId=2 then 1 else 0 end) as cd,
sum(case when typeId=3 then 1 else 0 end) as zt,
sum(case when typeId=4 then 1 else 0 end) as qj,
sum(case when typeId=4 then 1 else 0 end) as qj,
sum(case when typeId=8 then 1 else 0 end) as kk,
')->where($checkWhere)->select();