SQL语句中DQL的编写顺序以及执行顺序

176 阅读1分钟

DQL语句的编写顺序为: select ... from ... where ... group by ... having ... order by ... limit ...

DQL语句的执行顺序为: from ... where ... group by ... having ... select ... order by ... limit ...