Posted on 2008-11-21 09:37
Prayer 閱讀(1208)
評(píng)論(0) 編輯 收藏 引用 所屬分類:
數(shù)據(jù)庫(kù),SQL 、
DB2
示例一
SELECT 學(xué)號(hào), 姓名,
等級(jí)=
CASE
WHEN 總學(xué)分 IS NULL THEN ‘尚未選課’
WHEN 總學(xué)分 < 50 THEN ‘不及格’
WHEN 總學(xué)分 >=50 and 總學(xué)分<=52 THEN ‘合格’
ELSE ‘優(yōu)秀’
END FROM XS WHERE 專業(yè)名=’計(jì)算機(jī)’
示例二
update employee
set e_wage =
case
when job_level = ’1’ then e_wage*1.08
when job_level = ’2’ then e_wage*1.07
when job_level = ’3’ then e_wage*1.06
else e_wage*1.05
end
示例三
select a, (case a when 1 then '中' else '國(guó)' end) AS B from table1 軟件開(kāi)發(fā)網(wǎng)