两个条件分组统计sql
来源:互联网 发布:整容锥子脸 知乎 编辑:程序博客网 时间:2024/06/06 05:31
applyInfo:
SELECT
SUM(
IF (
a.certificate_level_id = 'ZSLX001',
1,
0
)
) AS typeA,
SUM(
IF (
a.certificate_level_id = 'ZSLX002',
1,
0
)
) AS typeB,
SUM(
IF (
a.certificate_level_id = 'ZSLX003',
1,
0
)
) AS typeC,
COUNT(*) AS total,
i.organization_name AS organizationName
FROM
applyinfo a
LEFT JOIN identifyorganization i ON a.identifyOrganizationId = i.id
WHERE
a.current_node = 999
AND a.`status` = 1
GROUP BY
a.identifyOrganizationId
SELECT
SUM(
IF (
a.certificate_level_id = 'ZSLX001',
1,
0
)
) AS typeA,
SUM(
IF (
a.certificate_level_id = 'ZSLX002',
1,
0
)
) AS typeB,
SUM(
IF (
a.certificate_level_id = 'ZSLX003',
1,
0
)
) AS typeC,
COUNT(*) AS total,
i.organization_name AS organizationName
FROM
applyinfo a
LEFT JOIN identifyorganization i ON a.identifyOrganizationId = i.id
WHERE
a.current_node = 999
AND a.`status` = 1
GROUP BY
a.identifyOrganizationId
阅读全文
0 0
- 两个条件分组统计sql
- sql分组统计查询 count带条件
- sql分组按条件统计count case when then
- 按条件分组统计信息
- sql分组统计语句
- oracle sql 分组统计
- sql 分组统计
- oracle分组统计sql
- [转]sql分组统计
- sql分组统计、最大值
- SQL分组统计查询
- sq更新语句条件子查询中有分组统计的sql,导致错误1093
- SQL按条件统计
- SQL 分类条件统计
- sql多条件统计
- sql技巧-构造分组条件
- sql server数据分组统计
- SQL TOP N 分组统计
- Rxjava的原理以及基本用法
- (javax)javaBean转xml
- ueditor编辑器asp版不能上传图片的解决方法 500错误
- 高并发下线程安全的单例模式(最全最经典)
- 菜鸟前端日记9 (原生JS--字符串的操作方法)
- 两个条件分组统计sql
- Spring MVC静态资源处理
- 人工智能+旅游大数据的未来,将迎来酒店行业数据可视化
- Android线程间消息机制-Handler源码分析(FrameWork)
- MongoDB 更新文档
- HTTP状态码大全
- svn检出数据的方式
- C#连接数据库最基本操作之sql语句 DML
- Mysql上查询字段多行变成一行,函数小技巧.