正常执行sql的查询顺序:
select … from … where … group by … having … order by … limit的执行顺序
但是执行sql的时候,数据库是怎么执行的呢 ?
简单:
from>where>group by>having>select>order by>limit
复杂: from > join on > where > group by > avg ,sum ... > having > select > distinct > order by