sql语法:
Select <列名|表达式|函数|常量>
From 表名
[Where 条件]
[group by 分组依据]
[having 分组条件]
[order by 排序(desc|asc)]
[limit 分页数据]
Sql语句的执行顺序
01.from
02.where
03.group by
04.having
05.select
06.order by
07.limit
本文共 251 字,大约阅读时间需要 1 分钟。
sql语法:
Select <列名|表达式|函数|常量>
From 表名
[Where 条件]
[group by 分组依据]
[having 分组条件]
[order by 排序(desc|asc)]
[limit 分页数据]
Sql语句的执行顺序
01.from
02.where
03.group by
04.having
05.select
06.order by
07.limit
转载于:https://www.cnblogs.com/shishibuwan/p/10842707.html