原表 course:
courseId | courseName | score |
---|---|---|
1 | java | 70 |
2 | oracle | 90 |
3 | xml | 40 |
查询结果为:
courseId | courseName | score | mark |
---|---|---|---|
1 | java | 70 | pass |
2 | oracle | 90 | pass |
3 | xml | 40 | fail |
SELECT
courseId, courseName, score,
(CASE WHEN
score >= 60 THEN 'pass'
WHEN score < 60 THEN 'fail'
END)
AS
mark
FROM
course