oracle、mysql和sqlserver分页
sql server row number分页：
select b.* FROM ( select row_number() over(order by t.id desc) as rownumber, t.* from table_name t ) as b where b.rownumber <= #endIndex# and b.rownumber >= #beginIndex#
mysql limit分页：
SELECT t.* FROM (SELECT id FROM table_name ORDER BY gmt_create DESC LIMIT #startRow#, #pageSize#) AS a, table_name AS t FORCE INDEX(PRIMARY) WHERE a.id = t.id
oracle分页：
select * from ( select t1.* , rownum linenum from ( select t.* from table_name t order by t.GMT_MODIFY desc ) t1 where rownum <= #endIndex#) t2 where t2.linenum >= #beginIndex#
欢迎大家阅读《oracle、mysql跟sqlserver分页_mysql》,跪求各位点评，by 搞代码
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：oracle、mysql跟sqlserver分页_mysql
转载请注明原文链接：oracle、mysql跟sqlserver分页_mysql
