统计分析 Access

最新推荐文章于 2021-06-28 10:34:01 发布

新田

最新推荐文章于 2021-06-28 10:34:01 发布

阅读量701

点赞数

分类专栏：数据库文章标签： access date

本文链接：https://blog.csdn.net/tem168/article/details/4422183

版权

数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

数量统计，数量比率统计，合格率统计，合格比率统计

select InspectType,Format(checkDate,'yyyy-MM-dd') as Date1,count(*)as amount,round(round(count(*) ,2)/(select count(*) from (select carcheck.id,carcheck.VieCode,carcheck.checkType,carcheck.checkResult,carcheck.checkDate,TestPendingVie.InspectType from carcheck,TestPendingVie where carcheck.id=TestPendingVie.TestID) ) ,2) as amountRate,SUM(iif(checkResult='1',1,0)) AS PassCount,round(round(SUM(iif(checkResult='1',1,0)),3) / COUNT(*) ,3)*100 AS PassPercent,round(round(SUM(iif(checkResult='1',1,0)) ,3) /(SELECT COUNT(*) FROM (select carcheck.id,carcheck.VieCode,carcheck.checkType,carcheck.checkResult,carcheck.checkDate,TestPendingVie.InspectType from carcheck,TestPendingVie where carcheck.id=TestPendingVie.TestID) ) ,3) AS PassRate from (select carcheck.id,carcheck.VieCode,carcheck.checkType,carcheck.checkResult,carcheck.checkDate,TestPendingVie.InspectType from carcheck,TestPendingVie where carcheck.id=TestPendingVie.TestID) group by InspectType,Format(checkDate,'yyyy-MM-dd') order by InspectType