摘要： 表如下：完成每个企业、每年的超标比例SQL：select EnterpriseCode as UID, year(MonitorTime) as 'Year' , EnterpriseName as 名称, ( SUM(OverStatus)*100.0/(count(*)) ) as AMOUNT from Ent_EnterpriseOverWeightStatusDay where CHARINDEX(CA... 阅读全文