mysql查询语句
mysql查询语句
SELECT
sortid as '班级',
max(CASE xskc WHEN '总分' THEN kspjf ELSE 0 END) AS '总分',
max(CASE xskc WHEN '数学' THEN kspjf ELSE 0 END) AS '数学',
max(CASE xskc WHEN '英语' THEN kspjf ELSE 0 END) AS '英语',
max(CASE xskc WHEN '生物' THEN kspjf ELSE 0 END) AS '生物'
FROM qb_fen_content_13
GROUP BY sortid为什么查询出来的结果全是0我希望显示
from qb_fen_content_13
where xskc = '总分'测试一下,估计根本没有符合条件的记录。