摘要:
select val1.serial_no beanKey, val1.fail beanValNeed,val2.total beanValTotalfrom(select count(guid) fail ,serial_nofrom `sqm`.`sqm_value_quality_station` WHERE result='1'GROUP BY serial_no) val1left join (select count(guid) total,serial_nofrom `sqm`.`sqm_value_quality_station` GROUP BY seria
阅读全文