HAVING

2023-11-29  本文已影响0人  xueyueshuai

@ 你想要筛选出订单数量大于等于3的客户,可以这样写:

SELECT customer_id, COUNT(*) AS order_count
FROM orders
GROUP BY customer_id
HAVING order_count >= 3;
上一篇 下一篇

猜你喜欢

热点阅读