题海让大学四年没有难题
白天模式登陆

题目详情

单选题 在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

Copyright © 2022 津ICP备2021001502号