原始sql:
select sc_grade, case
when sc_grade >0 and sc_grade <60 then '不及格'
when sc_grade >=60 and sc_grade <=70 then '及格'
when sc_grade >70 and sc_grade <=80 then '良好'
when sc_grade >80 and sc_grade <=90 then '中等'
when sc_grade >90 and sc_grade <=100 then '优秀'
else '其他' end as grade_rank
from t_student_course where sc_date='2019-06-06' and course_id='2'
xml中的写法
写法1:
原符号 < <= > >= & ' "
替换符号 < <= > >= & ' "
例:
select sc_grade, case
when sc_grade >= 0 and sc_grade < 60 then '不及格'
when sc_grade >= 60 and sc_grade <= 70 then '及格'
when sc_grade >= 70 and sc_grade <= 80 then '良好'
when sc_grade >= 80 and sc_grade <= 90 then '中等'
when sc_grade >= 90 and sc_grade <= 100 then '优秀'
else '其他' end as grade_rank
from t_student_course where sc_date=#{sc_date} and course_id=#{course_id}
写法2
>= 的写法 <![CDATA[ >= ]]>
<= 的写法 <![CDATA[ <= ]]>
例:
select sc_grade, case
when sc_grade <![CDATA[ >= ]]> 0 and sc_grade <![CDATA[ < ]]> 60 then '不及格'
when sc_grade <![CDATA[ >= ]]> 60 and sc_grade <![CDATA[ <= ]]> 70 then '及格'
when sc_grade <![CDATA[ > ]]> 70 and sc_grade <![CDATA[ <= ]]> 80 then '良好'
when sc_grade <![CDATA[ > ]]> 80 and sc_grade <![CDATA[ <= ]]> 90 then '中等'
when sc_grade <![CDATA[ > ]]> 90 and sc_grade <![CDATA[ <= ]]> 100 then '优秀'
else '其他' end as grade_rank
from t_student_course where sc_date=#{sc_date} and course_id=#{course_id}