1、oracle数据库:(注:tableName.id指的是tableName的主键)select * from (select tableName.*,rownum as con fr
1、oracle数据库:(注:tableName.id指的是tableName的主键)
select * from
(select tableName.*,rownum as con from tableName
where rownum <= m
order by tableName.id desc)
where con >= n;
2、sqlServer数据库:(注:tableName.id指的是tableName的主键)
实现原理解释:
1)先查出前m面条记录
2)再查出前n面条记录
3)最后通过条件过滤掉前m条记录
方法一:
select top n-m+1 * from tableName
where tableName.id not in
(select top m tableName.id from tableName order by desc tableName.id)
order by tableName.id
方法二:
select top n-m+1 * from tableName as a where not exists
(select * from
(select top m * from tableName order by id desc) b
where b.id = a.id)
order by id desc
3、Mysql数据库:
select * from tableName limit m, n;
--结束END--
本文标题: 三大数据库如何获取表中的第m条到第n条记录(n大于m)
本文链接: https://www.lsjlt.com/news/42529.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
2024-05-08
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0