SELECT measure_date,
SUM(IF(`factor_code`='w01001',measure_value,0)) as 'pH',
SUM(IF(`factor_code`='w01009',measure_value,0)) as '溶解氧',
SUM(IF(`factor_code`='w01019',measure_value,0)) as '高锰酸盐指数',
SUM(IF(`factor_code`='w21003',measure_value,0)) as '氨氮',
SUM(IF(`factor_code`='w21011',measure_value,0)) as '总磷',
SUM(IF(`factor_code`='w21001',measure_value,0)) as '总氮'
FROM dm_auto_monitor_well_detail
where well_code = 'A130900_2007'
GROUP BY measure_date
mysql行转列
最新推荐文章于 2024-08-01 08:23:29 发布