首先得到的不同的组合order_no
和invoice_total
再汇总:
SELECT SUM(invoice_total) AS invoicetotal
FROM (
SELECT DISTINCT order_no, invoice_total
FROM p_orders
WHERE plain_date='2020-12-23' AND o_status='Delivered'
) t
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句