ver:9.4.0.5216 display ok, from 9.4.0.5217 display error
charset display error
ver:9.4.0.5126
SELECT value_date, value_type, block_code,
MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 运行小时
,
MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `最高负荷
FROM kpi_sctj_value
GROUP BY value_date, value_type, block_code
ver:9.4.0.5127
SELECT value_date, value_type, block_code,
MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 杩愯灏忔椂
,
MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `鏈€楂樿礋鑽穈
FROM kpi_sctj_value
GROUP BY value_date, value_type, block_code
ver:9.4.0.5126
SELECT value_date, value_type, block_code,
MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 运行小时
,
MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `最高负荷
FROM kpi_sctj_value
GROUP BY value_date, value_type, block_code
ver:9.4.0.5127
SELECT value_date, value_type, block_code,
MAX(CASE item_code WHEN 'ZH000010' THEN item_value END) AS 杩愯灏忔椂
,
MAX(CASE item_code WHEN 'ZH000011' THEN item_value END) AS `鏈€楂樿礋鑽穈
FROM kpi_sctj_value
GROUP BY value_date, value_type, block_code
Please login to leave a reply, or register at first.