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欢迎编程高手加入.
***********************************