use pubs --使用pubs数据库
--简单型CASE表达式
select distinct a= --distinct是取消重提,a是列名
case state --state是一个列名
when 'CA' then 'ccaa'
else 'd'
end
from authors
select distinct state as a from authors
select distinct state b from authors
select distinct c=state from authors
--搜索型CASE表达式
select 'tex=t a'= --一列名,其中有空格则加单引号
case
when price is NULL then 'not yet priced'
when price <10 then 'very reasonable title'
when price >=10 and price<20 then 'coffee table title'
else 'expensive book!'
end
from titles