SQL語法HAVING

同 GROUP BY 的例子在 GROUP BY 敘述後加入 HAVING 敘述如下

HAVING 後接 COUNT(*) > 5 表示只取資料筆數大於5的組別

SELECT GP_name,SUM(C),COUNT(*)

from Tablename

GROUP BY GP_name

HAVING COUNT(*) >5

ORDER BY GP_name

最後可加個 ORDER BY 敘述表示以 GP_name 的欄位值做排序