select case when 1>0 then '1' when 1<0 then '0' else '0' end 记住最后要加end 转载于:https://www.cnblogs.com/zgaspnet/archive/2011/12/19/2293115.html