本文介绍了如何在sql中过滤值的乘法的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
i想要出售折扣优惠，如果数量2或其乘法（2,4,6,8等...）锄头来过滤a价格用这个
我的查询是
SELECT OFFER_MASTER0001.offer_type，OFFER_MASTER0001 .discount，OFFER_DETAILS0001.offer_itemcode，OFFER_DETAILS0001.offer_qty，OFFER_MASTER0001.item_code FROM OFFER_MASTER0001 LEFT OUTER JOIN OFFER_DETAILS0001 ON OFFER_MASTER0001.offer_no = OFFER_DETAILS0001.offer_no WHERE （OFFER_MASTER0001.item_code = ' 0000010'） AND （OFFER_MASTER0001.qty = 2 ） AND （OFFER_MASTER0001.date_from < ' 06-Mar-15 11:27:38 AM' AND OFFER_MASTER0001.date_to> ' 06-Mar-15 11:27:38 AM'）
这里是数量= 2但是我需要数量的所有倍数请帮帮我
解决方案
hi,
i want give discount offer for sale if the quantity 2 or its multiplication (2,4,6,8 etc ..) hoe to filter a value with this
my Query is
SELECT OFFER_MASTER0001.offer_type,OFFER_MASTER0001.discount,OFFER_DETAILS0001.offer_itemcode, OFFER_DETAILS0001.offer_qty,OFFER_MASTER0001.item_code FROM OFFER_MASTER0001 LEFT OUTER JOIN OFFER_DETAILS0001 ON OFFER_MASTER0001.offer_no = OFFER_DETAILS0001.offer_no WHERE (OFFER_MASTER0001.item_code = '0000010') AND (OFFER_MASTER0001.qty = 2) AND (OFFER_MASTER0001.date_from < '06-Mar-15 11:27:38 AM' AND OFFER_MASTER0001.date_to > '06-Mar-15 11:27:38 AM')
here is quantity = 2 but i need all multiplication amount of the quantity please help me
解决方案
这篇关于如何在sql中过滤值的乘法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！