- limit: 对所取得的数据再进行数量上的筛选,也就是分页限制,一页需要取得多少条数据,从某条开始取到指定的多少条。
select * from test limit 页码,每页条数;
- 测试数据: mysql> select * from test; +----+------+------+ | id | name | age | +----+------+------+ | 1 | dzm | 20 | | 2 | xyq | 20 | | 3 | xyq | 20 | | 4 | djy | 5 | | 5 | NULL | NULL | +----+------+------+
取出年龄最大的 3 个人,并按倒序排列 mysql> select * from test order by age desc limit 0,3; +----+------+------+ | id | name | age | +----+------+------+ | 1 | dzm | 20 | | 2 | xyq | 20 | | 3 | xyq | 20 | +----+------+------+