select Cxzb_nr,Cxzb_dw,Cxzb_dwxb from Cxzb where
case
when @jibie= '3 ' then [email protected]
when @jibie= '2 ' then [email protected]
else [email protected]
end
根据条件给出查询条件?这么写对马?该怎么写啊??
------解决方案--------------------
select Cxzb_nr,Cxzb_dw,Cxzb_dwxb from Cxzb where Cxzb_dw=
case
when @jibie= '3 ' then @danwei
when @jibie= '2 ' then @xuesh
else @www
end