本文介绍了在不同数据库系统中实现分页查询的方法，包括SqlServer、Oracle及MySql，并提供了具体的SQL语句示例。
选取第m到n记录(用于分页)
SqlServer
select t2.* from
(select top n-m t1.* from (select top n * from Tablename as t order by t.F1)) as t1 order by t1.F1
desc) as t2 order by t2.F1
Oracle
select * from (select rownum r ,t.* from Tablename t where t.r<n) t1 where t1.r>m and t1.r<n
MySql
select * from Tablename t order by t.F1 limit n,m-n+1
扫一扫
5395
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
