写这样的查询就可以打印你想要的效果SELECT 'cpys' As qz, SUM(CASE cpys WHEN '逻辑思维' THEN qz END) AS 逻辑思维, SUM(CASE cpys WHEN '个人影响力' THEN qz END) AS 个人影响力, SUM(CASE cpys WHEN '思路与内容' THEN qz END) AS 思路与内容 FROM cpxt*********************************** 高级群号:16497064欢迎编程高手加入. ***********************************
SUM(CASE cpys WHEN '逻辑思维' THEN qz END) AS 逻辑思维,
SUM(CASE cpys WHEN '个人影响力' THEN qz END) AS 个人影响力,
SUM(CASE cpys WHEN '思路与内容' THEN qz END) AS 思路与内容
FROM cpxt***********************************
高级群号:16497064欢迎编程高手加入.
***********************************