您好,登錄后才能下訂單哦!
CASE用法
CASE
WHEN condition1 THEN returnvalue1
WHEN condition 2 THEN returnvalue2
WHEN condition 3 THEN returnvalue3
ELSE defaultreturnvalue
END
相當(dāng)于if…else…else….
SELECT FName, FWeight,
(CASE
WHEN FWeight<40 THEN ‘瘦瘦'
WHEN FWeight>50 THEN ‘肥肥'
ELSE 'ok'
END)
as isnormal
FROM T_Person
create table bs
(
bsname char(20),
bsflag char(20),
bstime datetime
)
insert bs values('火箭','勝','2008-01-10')
insert bs values('火箭','負(fù)','2008-01-11')
insert bs values('火箭','勝','2008-01-10')
insert bs values('公牛','負(fù)','2008-01-10')
insert bs values('公牛','勝','2008-01-11')
insert bs values('公牛','負(fù)','2008-01-10')
select * from bs
select bsname,勝=sum(case when bsflag= '勝' then 1 else 0 end),
負(fù)=sum(case when bsflag='負(fù)' then 1 else 0 end)
from bs group by bsname
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。