Java学习 --- MySQL的排序与分页查询

目录

一、ORDER BY

二、升序ASC

三、降序DESC

二、分页查询

2.1mysql5的分页查询

 2.2mysql8的分页查询

---

一、ORDER BY

#order by 默认是升序
SELECT employee_id,last_name,salary FROM `employees` ORDER BY salary;

 

二、升序ASC

select employee_id,last_name,salary from `employees` order by salary asc;

三、降序DESC

SELECT employee_id,last_name,salary FROM `employees` ORDER BY salary DESC;

 

二、分页查询

2.1mysql5的分页查询

#分页查询
SELECT*FROM emp ORDER BY empno LIMIT 每页显示记录数*（第几页-1）,每页记录数
#按序号取出
SELECT*FROM emp ORDER BY empno DESC LIMIT 5,5

 2.2mysql8的分页查询

select employee_id,last_name,salary FROM `employees` ORDER BY salary limit 2 offset 31;