sql - Oracle SQL if 语句？

Question

如何检查 salesman_id 中的某个值是否为空，如果是，则将其分配给其他值（在本例中为 0）？

这是我到目前为止所写的：

SELECT O.SALESMAN_ID, SUM(OI.UNIT_PRICE * QUANTITY)
FROM ORDERS O, ORDER_ITEMS OI
GROUP BY O.SALESMAN_ID
ORDER BY O.SALESMAN_ID;

标签： sqloracle

Answer 1

SELECT nvl(O.SALESMAN_ID,0), SUM(OI.UNIT_PRICE * QUANTITY)
FROM ORDERS O, ORDER_ITEMS OI
GROUP BY nvl(O.SALESMAN_ID,0)
ORDER BY 1;