select语句
1.去除重复行:distinct
例如:select distinct department_id from employees
2.模糊查询:like %:代表不确定个数的字符 _:代表一个不确定字符 转义符:\
例如:select last_name from employees where last_name like '_a%'
3.排序:order by 升序(默认):asc 降序:desc
例如:select * from employees order by salary asc/desc
二级排序:先将id降序排列,再将salary升序排列。
select * from employees order by department_id desc , salary asc(可不写)
4.分页:limit limit a:从0开始显示a条数据 limit a,b:从a+1开始显示b条数据
公式:每页显示pageSize条数据,此时显