学习笔记(01):MySQL数据库从入门到搞定实战-查询结果排序与分页

立即学习:https://edu.youkuaiyun.com/course/play/27328/362528?utm_source=blogtoedu

limit分页公式：

limit (page-1)*row_count,row_count;

 

按工资排序：

select *from employee order by salary;

select *from employee order by salary asc;

select *from employee order by salary desc;

按性别和工资排序：

select *from employee order by sex,salary desc;

 

每页5条分页：

select * from employee limit 0,5;

select * from employee limit 5,5;

select * from employee limit 10,5;