一、简单查询
from > distinct > select > order by > limit
(1) 普通查询:select name,age from students;
(2) 起别名查询:select s.name,s.age from students as s;
(3) 分页查询:select name,age from students limit 0,10;
(4)排序查询:select name,age,id from students order by age desc,id asc;
(5)去重查询:select distinct age from students;
二、条件查询
from > where > distinct > select > distinct > order by > limit
eg: select name,age, from students where name=‘xiaoming’ and age=18;
三、高级查询(聚合函数)
sum求和 | avg平均数 | max最大数 | 最小数min
group by | 分组查询
(1) 求班级男女平均年龄分别为多少?