我如何获得SUM(IF())MySQL的OR [英] How I get OR to SUM(IF()) MySQL

问题描述

我有问题.我需要找出如何按此顺序放置OR:

i have a problem. I need to find out, how to put OR in this order:

SELECT ROUND(o.`total_products`  / c.`conversion_rate` - 
           (SUM(IF(pa.wholesale_price = "0" , p.wholesale_price, 
           pa.wholesale_price)*od.product_quantity)))

我需要像这样将OR与"0"放在一起:

And I need to put OR together with "0" like this:

SELECT ROUND(o.`total_products`  / c.`conversion_rate` - 
           (SUM(IF(pa.wholesale_price = "0" OR "IS NULL", p.wholesale_price, 
           pa.wholesale_price)*od.product_quantity)))

我想要这个结果:如果pa.wholesale_price为零或不存在行，请使用p.wholesale_price.如果存在pa.wholesale_price，请使用pa.wholesale_price.

I want this result: If pa.wholesale_price is zero or row does not exist, use p.wholesale_price. If pa.wholesale_price exist, use pa.wholesale_price.

有人可以帮助我吗?

推荐答案

尝试

IF((pa.wholesale_price ="0")OR(pa.wholesale_price IS NULL)......

IF((pa.wholesale_price = "0") OR (pa.wholesale_price IS NULL)......

这篇关于我如何获得SUM(IF())MySQL的OR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！