当前位置：网站首页>8. Paging query

8. Paging query

2022-04-23 07:40:00 【Ah Dai cloth clothes cool】

8. Paging query

1. Before querying salary 3 name 

select * from emp 
order by sal desc 
limit 0,3;

select * from emp
order by sal desc
limit 3;

2. Query salary greater than 1000 Of the 4 To 8 Users 

select * from emp where sal>1000 limit 3,5;

3. Query the lowest paid user 

select * from emp order by sal limit 1;

4. Each page shows 4 strip (pageSize The size of each page ), According to the first 3 The content of the page (pageIndex Page number )

select * from emp
limit (pageIndex-1)*pageSize,pageSize;

版权声明
本文为[Ah Dai cloth clothes cool]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/04/202204230622239306.html

边栏推荐

猜你喜欢

随机推荐