SELECT nvarcharsname,intsage, CASE charSsex WHEN 'm' THEN '男' ELSE '女' END AS sex FROM student 转载于:https://www.cnblogs.com/jcdd-4041/p/3515981.html