MaxCompute SQL的WHERE關鍵字無法與彙總函式一起使用,此時您可以使用HAVING子句來實現。
命令格式如下。
SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name
HAVING aggregate_function(column_name) operator value
例如有一張訂單表
Orders
,包括客戶名稱(Customer
)、訂單金額(OrderPrice
)、訂單日期(Order_date
)和訂單號(Order_id
)四個欄位。現在需要尋找訂單總額少於2000的客戶,SQL語句如下。 SELECT Customer,SUM(OrderPrice) FROM Orders
GROUP BY Customer
HAVING SUM(OrderPrice)<2000