MySQL中OFFSET和FETCH的详解
| OFFSET & FECTH 关键字与ORDER BY结合使用，实现对查询结果的分页 一、单独使用OFFSET: 示例：查询所有职员的信息，按雇佣日期排序并跳过前285条记录（共290条） 1 USE AdventureWorks20142 SELECT [BusinessEntityID],[HireDate],[JobTitle]3 FROM [HumanResources].[Employee]4 ORDER BY [BusinessEntityID]5 OFFSET 285 ROWS 查询结果： BusinessEntityID HireDate JobTitle1 286 2013-05-30 Sales Representative2 287 2012-04-16 European Sales Manager3 288 2013-05-30 Sales Representative4 289 2012-05-30 Sales Representative5 290 2012-05-30 Sales Representative 二、OFFSET和FECTH结合使用： 示例：查询所有职员的信息，按雇佣日期排序并跳过前10条记录再显示之后的5条记录 1 USE AdventureWorks20142 SELECT [BusinessEntityID],[HireDate],[JobTitle]3 FROM [HumanResources].[Employee]4 ORDER BY [BusinessEntityID]5 OFFSET 10 ROWS6 FETCH NEXT 5 ROWS ONLY 查询结果： BusinessEntityID HireDate JobTitle1 11 2010-12-05 Senior Tool Designer2 12 2007-12-11 Tool Designer3 13 2010-12-23 Tool Designer4 14 2010-12-30 Senior Design Engineer5 15 2011-01-18 Design Engineer 以上就是MySQL中OFFSET和FETCH的详解的内容， |