SELECT 学号, 姓名, 等级= CASE WHEN 总学分 ISNULLTHEN ‘尚未选课’ WHEN 总学分 <50THEN ‘不及格’ WHEN 总学分 >=50and 总学分<=52THEN ‘合格’ ELSE ‘优秀’ ENDFROM XS WHERE 专业名=’计算机’
示例二示例三
select a, (case a when 1 then '中' else '国' end) AS B from table1
示例四
USE pubs GO SELECT CASE WHEN price ISNULLTHEN'Unpriced' WHEN price <10THEN'Bargain' WHEN price BETWEEN10and20THEN'Average' ELSE'Gift to impress relatives' ENDAS Range, Title FROM titles GROUPBY CASE WHEN price ISNULLTHEN'Unpriced' WHEN price <10THEN'Bargain' WHEN price BETWEEN10and20THEN'Average' ELSE'Gift to impress relatives' END, Title ORDERBY CASE WHEN price ISNULLTHEN'Unpriced' WHEN price <10THEN'Bargain' WHEN price BETWEEN10and20THEN'Average' ELSE'Gift to impress relatives' END, Title GO