SQL 重点

数据库统计并计数

• having子句的运用
• • 查询teacher表中类型type大于2

having子句的运用

查询teacher表中类型type大于2

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