Group having order by
常伴聚集函数
Select from where
查询全部列
去除重复
DISTINCT
比较>< ,between and
HAVING 用于group 分组
SELECT COUNT(dISTINCT sNO)
FROM sc;
Group by Sno
Having AVG(GRADE)>= 90;
SELECT Sno
From SC
Select SNO
FROM sc
Group by Sno
Having count(*)>3;
明天就不打算看课了 等一天时间消化一下