max(case
when a.coursename = '思想' and
a.termid = '0' and a.kcscore is null then
case (a.zhscore as 类型)
when a.coursename = '思想'and
a.termid = '0' and a.kcscore is not null then
case（ a.kcscore as 类型）
end) 思想
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024