SELECT id, (SELECT Score FROM Table_1 WHERE KeMu='数学' AND id=a.id)as 数学,(SELECT Score FROM Table_1 WHERE KeMu='语文' AND id=a.id)AS 语文,(SELECT Score FROM Table_1 WHERE KeMu='英语' AND id=a.id)AS 英语 FROM Table_1 aGROUP BY a.id
本文共 277 字，大约阅读时间需要 1 分钟。
SELECT id, (SELECT Score FROM Table_1 WHERE KeMu='数学' AND id=a.id)as 数学,(SELECT Score FROM Table_1 WHERE KeMu='语文' AND id=a.id)AS 语文,(SELECT Score FROM Table_1 WHERE KeMu='英语' AND id=a.id)AS 英语 FROM Table_1 aGROUP BY a.id
转载于:https://www.cnblogs.com/zhubaobao/p/4137076.html