mysql问题?求解。。。。
0
最佳答案
0
SELECT owner,
MAX(CASE WHEN a.key = 'name' THEN a.val ELSE NULL END) as 姓名,
MAX(CASE WHEN a.key = 'age' THEN a.val ELSE NULL END) as 年龄
FROM `table1` as a
WHERE owner = 1 group by owner
奖励园豆：5
嗯，给你满意吧。。。论哥
