成人高等教育 / 数据库基础与应用
正确率：100%
设SC表中记录成绩的列为：Grade，类型为int。若在查询成绩时，希望将成绩按‘优’、‘良’、‘中’、‘及格’和‘不及格’形式显示，正确的Case函数是（ ）。
- A、 Case Grade
When 90~100THEN'优'
When 80~89THEN'良'
When 70~79THEN'中'
When 60~69THEN'及格'
Else'不及格'
End - B、 Case
When Gradebetween 90 and 100THENGrade = '优'
When Gradebetween 80 and 89THENGrade = '良'
When Gradebetween 70 and 79THENGrade = '中'
When Gradebetween 60 and 69THENGrade = '及格'
ElseGrade = '不及格'
End - C、 Case
When Gradebetween 90 and 100THEN'优'
When Gradebetween 80 and 89THEN'良'
When Gradebetween 70 and 79THEN'中'
When Gradebetween 60 and 69THEN'及格'
Else'不及格'
End - D、 Case Grade
When 90~100THEN Grade = '优'
When 80~89THEN Grade = '良'
When 70~79THEN Grade = '中'
When 60~69THEN Grade = '及格'
ElseGrade = '不及格'
End
参考答案：
佳题速递：