再再再再再再问个问题 - 调试易

再再再再再再问个问题

WHERE (T1.PRICEBEFDI > T3.PRICE) >= '1'我想要的意思是，条件是 T1.PRICEBEFDI 大于 T3.PRICE 值小于的过滤掉

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

WHERE (T1.PRICEBEFDI > T3.PRICE)
WHERE (T1.PRICEBEFDI > T3.PRICE)  and T1.PRICEBEFDI>=1?
where T1.PRICEBEFDI > T3.PRICE and  T3.PRICE >= '1' ?
T1.PRICEBEFDI 大于 T3.PRICE ， 1 以下的过滤掉。
WHERE (T1.PRICEBEFDI >-T3.PRICE )>=1?
WHERE T1.PRICEBEFDI <= T3.PRICE and T1.PRICEBEFDI>=1还是要这样?
WHERE (T1.PRICEBEFDI -T3.PRICE )>=1
编辑不了。NUM   T1.PRICEBEFDI    T3.PRICE
1       10                  10
2       10.1               10
3       15                 10
结果是显示
NUM   T1.PRICEBEFDI    T3.PRICE
3       15                 10T1.PRICEBEFDI 大于 T3.PRICE 允许在1以下
WHERE (T1.PRICEBEFDI -T3.PRICE )>=1
where (T1.PRICEBEFDI-T3.PRICE)>=1为什么要加个“允许在1以下”什么意思？？
where (T1.PRICEBEFDI-T3.PRICE)>=1
WHERE (T1.PRICEBEFDI > T3.PRICE) and T3.PRICE>'1'
WHERE (T1.PRICEBEFDI > T3.PRICE) and (T1.PRICEBEFDI-T3.PRICE)>=1