参考手册

参考手册

实例 PostgreSQL GROUP BY 与 HAVING 一起使用实例

 
SELECT COUNT(customer_id), country
FROM customers
GROUP BY country
HAVING COUNT(customer_id) > 5;        
                    

输出结果

 count | country
-------+---------
    13 | USA
    11 | France
     9 | Brazil
     7 | UK
    11 | Germany
(5 rows)