sql - 我想减少 SQL SELECT SUM 重复聚合

Question

select sum(order_qty) as totalOrderQty, sum(stock_qty) as totalStockQty, sum(order_qty) - sum(stock_qty) as totalSubtract from inventory

我们可以将重复的聚合函数变为一个吗？

标签： sqlsumaggregate-functions

Answer 1

您不能在同一个选择中重复使用总和别名。但是，这里有一个稍微简化的版本：

SELECT
    SUM(order_qty) AS totalOrderQty,
    SUM(stock_qty) AS totalStockQty,
    SUM(order_qty - stock_qty) AS totalSubtract
FROM inventory;