sql server 如何where判断字段与字段之间的四则运算
例:select (ML/JE)*100 As mll from vwfh where mll<0.3 and mll>0.2 但是这种方法是不行的, 运行结果如下
请问我该如何判断
select (ML/JE)*100 As mll from vwfh where (ML/JE)*100 <0.3 and (ML/JE)*100>0.2
或者：
select mll from(
select (ML/JE)*100 As mll from vwfh
) a where mll<0.3 and mll>0.2
或者：
select mll from(
select (ML/JE)*100 As mll from vwfh
) a where mll<0.3 and mll>0.2
温馨提示：内容为网友见解，仅供参考
第1个回答 2013-07-04
select * from (
select (ML/JE)*100 As mll from vwfh)
where mll<0.3 and mll>0.2
select (ML/JE)*100 As mll from vwfh)
where mll<0.3 and mll>0.2
第2个回答 2013-07-04
where mll between 0.2 and 0.3
相似回答
