Create View stu_cur_view(Stu_num, Cur_nu, Grade)
As
Select Stum, Cur_num,
Case Grade
When '优秀' Then 95
When '良好' Then 85
When '中等' Then 75
When '及格' Then 65
When '不及格' Then 0
End Grade
From stu_cur_tab
As
Select Stum, Cur_num,
Case Grade
When '优秀' Then 95
When '良好' Then 85
When '中等' Then 75
When '及格' Then 65
When '不及格' Then 0
End Grade
From stu_cur_tab
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货