select factory_name as 工厂名称,actual_date as 日期 ,class_id as 班次,car_brand as 品牌,duty_part as 责任部门, io_problem_num as 问题项数1, function_problem_num as 问题项数2, rain_problem_num as 问题项数3, io_check_num as 车数1 function_check_num as 车数2 rain_check_num as 车数3 unqualified_rate as 不合格率 from ads_t022_qm_xszc_unqualified_rate_d 这个是数据库表里面的,工厂名称只有A B C三个工厂,品牌有D E F个品牌,怎么可以实现在A工厂下计算DEF相加后整体的问题数,相当预览时包含D E F 整体,同时ABC三个工厂也可以AB合并成一个,ABC合并成一个,来计算。图片里面达成结果都是问题数/车数。求各位大神帮忙 |
最佳回答 |
||||
0
|
|