mysqloffset什么意思_MySQL中OFFSET和FETCH的详解

OFFSET & FECTH 关键字与ORDER BY结合使用，实现对查询结果的分页

一、单独使用OFFSET:

示例：查询所有职员的信息，按雇佣日期排序并跳过前285条记录(共290条)1 USE AdventureWorks2014

2 SELECT [BusinessEntityID],[HireDate],[JobTitle]

3 FROM [HumanResources].[Employee]

4 ORDER BY [BusinessEntityID]

5 OFFSET 285 ROWS

查询结果：BusinessEntityID HireDate JobTitle

1 286 2013-05-30 Sales Representative

2 287 2012-04-16 European Sales Manager

3 288 2013-05-30 Sales Representative

4 289 2012-05-30 Sales Representative

5 290 2012-05-30 Sales Representative

二、OFFSET和FECTH结合使用：

示例：查询所有职员的信息，按雇佣日期排序并跳过前10条记录再显示之后的5条记录1 USE AdventureWorks2014

2 SELECT [BusinessEntityID],[HireDate],[JobTitle]

3 FROM [HumanResources].[Employee]

4 ORDER BY [BusinessEntityID]

5 OFFSET 10 ROWS

6 FETCH NEXT 5 ROWS ONLY

查询结果：BusinessEntityID HireDate JobTitle

1 11 2010-12-05 Senior Tool Designer

2 12 2007-12-11 Tool Designer

3 13 2010-12-23 Tool Designer

4 14 2010-12-30 Senior Design Engineer

5 15 2011-01-18 Design Engineer

以上就是MySQL中OFFSET和FETCH的详解的内容，更多相关内容请关注PHP中文网(www.gxlcms.com)！

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：php中文网