SQL语句:
SELECT a.id,
MAX(CASE a.type WHEN ‘a’ THEN a.number ELSE 0 END) ‘a’,
MAX(CASE a.type WHEN ‘b’ THEN a.number ELSE 0 END) ‘b’,
MAX(CASE a.type WHEN ‘c’ THEN a.number ELSE 0 END) ‘c’
FROM a
GROUP BY a.id
sql行转列问题
最新推荐文章于 2023-03-19 18:19:13 发布