本文介绍了使用SQL进行高级查询的方法，包括如何筛选特定供应商的产品数量、客户的订单数量以及价格高于特定阈值的产品等。通过实际案例展示了GROUP BY与HAVING子句的应用。
SELECT vend_id,COUNT(*) AS num_prods FROM products GROUP BY vend_id HAVING COUNT(num_prods) >= 3;
SELECT cust_id ,COUNT(*) AS orders FROM orders GROUP BY cust_id HAVING COUNT(*) >=2;
SELECT vend_id , COUNT(*) as num_prods FROM products WHERE prod_price >=5 GROUP BY vend_id HAVING COUNT(num_prods) >= 2;
SELECT vend_id,COUNT(*) AS num_prods FROM products;
SELECT order_num,SUM(quantity*item_price) AS sum_price FROM orderitems GROUP BY order_num HAVING sum_price >= 50 ORDER BY sum_price DESC;
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
