select distinct 字段1,字段2,字段3…… from 库名.表名 Where 约束条件 Group by 分组依据 Having 过滤条件 Order by 排序的字段 Limit 限制显示的条数 ;
关键字执行的优先级 From Where Group by Having Distinct Order by Limit
select distinct 字段1,字段2,字段3…… from 库名.表名 Where 约束条件 Group by 分组依据 Having 过滤条件 Order by 排序的字段 Limit 限制显示的条数 ;
关键字执行的优先级 From Where Group by Having Distinct Order by Limit