在mysql中,读取顺序:
开始----from---where----group by---having---order by---select ----limit
例子:
原始表格信息:
语句:查询成绩有1门以上不及格的学生
select name,count(*) as gk
from aa
where score<60
group by name
having gk>=1
结果:
随机两个学生;
select name ,count(*) as gk
from aa
where score<60
group by name
having gk>=1
order by rand()
limit 2