sql 统计语句 优化
sql 统计语句 优化
select sum(undoneCount)+sum(doneCount)+sum(rejectedCount) totalNum,max(undoneCount) undoneCount,max(doneCount) doneCount,max(rejectedCount) rejectedCount,process_name,process_id from (
select
sum(case when a.status in (0,1) then 1 else 0 end) u
原创
2020-09-30 11:43:14 ·
278 阅读 ·
0 评论