参考手册

参考手册

实例 PostgreSQL GROUP BY，LEFT JOIN 与 HAVING 一起使用实例

 
SELECT customers.customer_name, SUM(products.price)
FROM order_details
LEFT JOIN products ON order_details.product_id = products.product_id
LEFT JOIN orders ON order_details.order_id = orders.order_id
LEFT JOIN customers ON orders.customer_id = customers.customer_id
GROUP BY customer_name
HAVING SUM(products.price) > 1000.00;        
                    

输出结果

         customer_name         |   sum
------------------------------+---------
 Lehmanns Marktstand          | 1088.29
 Rattlesnake Canyon Grocery   | 2399.99
 Hungry Owl All-Night Grocers | 1837.95
 Frankenversand               | 1067.41
 Mere Paillarde               | 1072.50
 HILARION-Abastos             | 1001.47
 Ernst Handel                 | 2891.35
 Bon app                      | 1122.55
 Great Lakes Food Market      | 1091.54
 Save-a-lot Markets           | 2788.48
 Queen Cozinha                | 1166.59
 Koniglich Essen              | 1290.48
 QUICK-Stop                   | 2842.45
 Hanari Carnes                | 1423.00
 Folk och fe HB               | 1098.58
 White Clover Markets         | 1314.93
 Berglunds snabbkoep          | 1507.48
(17 rows)