低调人生

摘要： 如要获取 result = '1' 的数量COUNT( CASE WHEN result = '1' THEN result END ) SELECT * FROM ( SELECT batchNo, serviceId, result, projectId, sum(passCount) AS passCount, COUNT( CASE WHEN result = '... 阅读全文