SQL55 分页查询employees表，每5行一页，返回第2页的数据

最新推荐文章于 2021-10-07 16:54:45 发布

linpanli

最新推荐文章于 2021-10-07 16:54:45 发布

阅读量347

点赞数

分类专栏：牛客网SQL练习题文章标签： sql 数据库 mysql

本文链接：https://blog.youkuaiyun.com/python_xiaobaib/article/details/119961949

版权

牛客网SQL练习题专栏收录该内容

61 篇文章

订阅专栏

描述
分页查询employees表，每5行一页，返回第2页的数据


drop table if exists  `employees` ; 
CREATE TABLE `employees` (
  `emp_no` int(11) NOT NULL,
  `birth_date` date NOT NULL,
  `first_name` varchar(14) NOT NULL,
  `last_name` varchar(16) NOT NULL,
  `gender` char(1) NOT NULL,
  `hire_date` date NOT NULL,
  PRIMARY KEY (`emp_no`));
INSERT INTO employees VALUES(10001,'1953-09-02','Georgi','Facello','M','1986-06-26');
INSERT INTO employees VALUES(10002,'1964-06-02','Bezalel','Simmel','F','1985-11-21');
INSERT INTO employees VALUES(10003,'1959-12-03','Parto','Bamford','M','1986-08-28');
INSERT INTO employees VALUES(10004,'1954-05-01','Chirstian','Koblick','M','1986-12-01');
INSERT INTO employees VALUES(10005,'1955-01-21','Kyoichi','Maliniak','M','1989-09-12');
INSERT INTO employees VALUES(10006,'1953-04-20','Anneke','Preusig','F','1989-06-02');
INSERT INTO employees VALUES(10007,'1957-05-23','Tzvetan','Zielinski','F','1989-02-10');
INSERT INTO employees VALUES(10008,'1958-02-19','Saniya','Kalloufi','M','1994-09-15');
INSERT INTO employees VALUES(10009,'1952-04-19','Sumant','Peac','F','1985-02-18');
INSERT INTO employees VALUES(10010,'1963-06-01','Duangkaew','Piveteau','F','1989-08-24');
INSERT INTO employees VALUES(10011,'1953-11-07','Mary','Sluis','F','1990-01-22');

--输出：
10006|1953-04-20|Anneke|Preusig|F|1989-06-02
10007|1957-05-23|Tzvetan|Zielinski|F|1989-02-10
10008|1958-02-19|Saniya|Kalloufi|M|1994-09-15
10009|1952-04-19|Sumant|Peac|F|1985-02-18
10010|1963-06-01|Duangkaew|Piveteau|F|1989-08-24

SQL练习题55（中等）：

select *
from employees
limit 5,5;

知识点

limit 偏移量,取数量
--其中的偏移量含义：隔多少条数据
--取数量的含义：展示多少条数据
--公式
limit 每页数量*（页数-1）,取数量