2021-05-08

手写hql

原表:

courseid coursename score

1 java 70
2 oracle 90
3 xml 40
4 jsp 30
5 servlet 80

为了便于阅读,查询此表后的结果显式如下(及格分数为60):

courseid coursename score mark

1 java 70 pass
2 oracle 90 pass
3 xml 40 fail
4 jsp 30 fail
5 servlet 80 pass

最终sql：

select
	courseid,
    coursename,
    score,
    if(score >=60 , pass,fail) mark
from
	原表