如何在sql中过滤值的乘法 [英] How to filter multiplication of a value in 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但是我需要数量的所有倍数请帮帮我

解决方案

试试添加条件如

  WHERE （数量％2）=  0  

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

解决方案

Try adding a condition like

WHERE (quantity%2) = 0

这篇关于如何在sql中过滤值的乘法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！