DQL语句的书写顺序与执行顺序 书写顺序: select … from … where … group by … having … order by … limit … 执行顺序: formwheregroup byhavingselectorder bylimit…