---排序

select * from student order by age asc; -- 默认就是升序 ascending

select * from student order by age desc; -- 默认就是降序 descending

select * from student order by age desc , id asc; -- 先按照年龄降序，再按id升序

--分页查询

limit -- 一次查询的条数 offset 偏移量

limit --  偏移量，一次查询的条数

select * from student limit 10 offset 0;

select * from student limit 10 offset 10;

select * from student limit 10 offset 20;

select * from student limit 0, 10;  偏移量0查询10条