先列出sql语句的执行顺序:
FROM<left_table>ON<join_condition><join_type> JOIN<right_table>WHERE<where_condition>GROUP BY<group_by_list>HAVING<having_condition>SELECTDISTINCT<select_list>ORDER BY<order_by_condition>LIMIT<limit_number>
1、LIMIT 语句
分页查询是最常用的场景之一,但也通常也是...