OFFSET
和 FETCH NEXT
子句来实现分页查询。,,``sql,SELECT *,FROM your_table,ORDER BY some_column,OFFSET (page_number 1) * page_size ROWS,FETCH NEXT page_size ROWS ONLY;,
`,,
page_number 是当前页码,
page_size` 是每页显示的记录数。OFFSET
和 FETCH NEXT
子句来实现分页查询。,,``sql,SELECT *,FROM your_table,ORDER BY some_column,OFFSET (page_number 1) * page_size ROWS,FETCH NEXT page_size ROWS ONLY;,
`,,
page_number 是当前页码,
page_size` 是每页显示的记录数。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.