题目详情
单选题 在SQL Server中某数据库中有表SC(sno, cno, grade),其中列grade类型为int.若在查询成绩时,希望将成绩按"优","良","中"、"及格"和"不及格"形式显示,则下列case函数中正确的是()
A. Case gradeWhen grade between 90 and 100 then grade='优'When grade between 80 and 89 then grade='良'When grade between 70 and 79 then grade='中'When grade between 60 and 69 then grade='及格'Else grade='不及格'End
B. Case gradeWhen grade between 90 and 100 then'优'When grade between 80 and 89 then'良'When grade between 70 and 79 then'中'When grade between 60 and 69 then'及格'Else '不及格'End
C. Case When grade between 90 and 100 then grade='优'When grade between 80 and 89 then grade='良'When grade between 70 and 79 then grade='中'When grade between 60 and 69 then grade='及格'Else grade='不及格'End
D. Case When grade between 90 and 100 then'优'When grade between 80 and 89 then'良'When grade between 70 and 79 then'中'When grade between 60 and 69 then'及格'Else '不及格'End
学科:数据库原理及实用技术
时间:2023-11-27 16:09:36
相关题目
相关作业