SQL 重點

資料庫統計并計數

• having子句的運用
• • 查詢teacher表中類型type大于2

having子句的運用

查詢teacher表中類型type大于2

SELECT COUNT(type) from teacher GROUP BY type having COUNT (type)>2;