分组数据

时间：2019-07-10 10:40:45 阅读：80 评论：0 收藏：0 [点我收藏+]

创建分组

SELECT  vend_id, COUNT(*) AS num_prods
FROM Profucts
GROUP BY vend_id;

GROUP BY 子句必须出现在WHERE子句之后，OEDER BY子句之前。

SELECT cust_id, COUNT(*) AS orders
FROM Orders
GROUP BY cust_id
HAVING COUNT(*) >= 2;

SELECT

FROM

WHERE

GROUP BY

HAVING

ORDER BY

SELECT cust_id
FROM Orders
WHERE order_num IN （SELECT order_num
                     FROM OrderItems
                     WHERE prod_id =‘RGAN01‘）;

原文：https://www.cnblogs.com/xjyxp/p/11162252.html

踩

(0)

评论一句话评论（0）

分享档案

更多>