SQL学习第一部分(概述):
操作符部分:
as (改名)
and/or/in
between and
is null
not
like(模糊查询): % / _
分组函数(聚集函数):
count()
sum()
avg()
max()
min()
一个完整的DQL语句怎么写?
执行语句 执行顺序(功能)
select 5(查找出分组过滤的结果)
..
from 1(所查询的表)
..
where 2(判断条件)
..
group by 3(分组)
..
having 4(再次过滤)
..
order by 6(排序)
..