oracle 9i 和 sql2005 分页sql代码

最新推荐文章于 2025-09-13 19:07:06 发布

转载最新推荐文章于 2025-09-13 19:07:06 发布 · 46 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/liufei88866/archive/2008/07/12/1241291.html

文章标签：

#数据库

本文介绍了使用Oracle 9i及SQL Server 2005进行分页查询的方法，通过具体的SQL语句示例展示了如何利用ROWNUM和ROW_NUMBER()函数实现数据的分页展示，适用于数据库开发人员。

oracle 9i -----string commandText = string.Format(@"select * from (select rownum r_id,Point.* from(select l.point_no,l.point_name,l.address,l.snc_code from POINT_CONNECTION l)Point) AlPoint where 1=1 and r_id between {1}*({0}-1)+1 and {1}*{0} order by point_no asc", nowPage, pageSize);

sql2005 ----string sql = string.Format(@"SELECT * FROM (select *,ROW_NUMBER() Over(order by user_id) as rowNum from UserInfo ) as myTablewhere rowNum between {1}*({0}-1)+1 and {1}*{0} order by user_id asc", nowpage, PageNavigate1.CountPerPage);nowpage当前页码/PageNavigate1.CountPerPage 每页显示多少条

转载于:https://www.cnblogs.com/liufei88866/archive/2008/07/12/1241291.html