34,576
社区成员
发帖
与我相关
我的任务
分享
select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE cast(sum(t1)-sum(t3)+sum(t2) as varchar(100))
END
select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE cast(sum(t1)-sum(t3)+sum(t2) as varchar)
END
select '数'=
case
when sum(t1)-sum(t3)+sum(t2)=0 then 'ok'
ELSE LTRIM(sum(t1)-sum(t3)+sum(t2))
END