SQL中类似三元运算符的语句

select (case when num>0 then 'Y' when num=0 then 'NG' else 'N' end) as column from table
posted @ 2011-03-22 13:11  TonnyGu  阅读(13176)  评论(0编辑  收藏  举报