SQL Server+MySQL数据库 查询字段的编程 7.5查询字段的编程.pptx

;Select sname as 学生，sno as 学号 from student Select sname 学生，sno 学号 from student Select学生=sname ，学号 =sno from student ;案例1：student表中性别的值为0和1， 想在显示查询结果时显示男或女 Select 姓名,case 性别 when ‘0’ then ‘男’ When ‘1’ then ‘女’ End as 性别 from student ;用五级制显示成绩 Select 学号, case When score =90 then ‘优秀’ When score =80 then ‘良好’ When score =70 then ‘中等’ When score =60 then ‘及格’ Else ‘不及格’ End as score from 成绩表;THANKS