当前位置：网站首页>MySQL realizes row to column SQL

MySQL realizes row to column SQL

2022-04-23 05:03:00 【Great Wall ol】

A way to transfer rows to columns , according to property Value of field a,b Convert to different columns , for example A,B Two 

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;

版权声明
本文为[Great Wall ol]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204220552270707.html

边栏推荐

猜你喜欢

随机推荐