一个行转列的办法,根据property字段的值a,b转换成不同得列,譬如A,B两列
SELECT date,
sum(CASE property WHEN 'a' THEN value ELSE 0 END) as 'A',
sum(CASE property WHEN 'b' THEN value ELSE 0 END) as 'B'
FROM `table` where date='2020-03-01' GROUP BY date;
一个行转列的办法,根据property字段的值a,b转换成不同得列,譬如A,B两列
SELECT date,
sum(CASE property WHEN 'a' THEN value ELSE 0 END) as 'A',
sum(CASE property WHEN 'b' THEN value ELSE 0 END) as 'B'
FROM `table` where date='2020-03-01' GROUP BY date;