sql记录

单表sql

select distinct 字段1,...,字段n from 库.表
where 条件
group by 分组字段
having 过滤
order by 排序字段
limit n;

执行顺序

from
where
group by
having
select
distinct
order by
limit