SQL Server数据库设计和高级查询[SQL Advance]

源代码在线查看: case多分支.sql

软件大小: 18542 K
上传用户: kelvinitc
关键词: SQL Advance Server 数据库设计
下载地址: 免注册下载 普通下载 VIP

相关代码

				SELECT * FROM stuMarks  --原始成绩
				print 'ABCDE五级显示成绩如下:'
				SELECT stuNo,成绩= CASE  
				                     WHEN writtenExam				                     WHEN writtenExam between 60 AND 69 THEN 'D'
				                     WHEN writtenExam between 70 AND 79 THEN 'C'
				                     WHEN writtenExam between 80 AND 89 THEN 'B'
				                     ElSE 'A'
				                  END
				             FROM stuMarks			

相关资源