oracle自带总页数分页sql

最新推荐文章于 2023-02-09 09:57:52 发布

转载最新推荐文章于 2023-02-09 09:57:52 发布 · 588 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/qbq01/p/6951276.html

文章标签：

#数据库

string strSQL = string.Format(@"select * from( with temp as (select * from * where {0} order by CREATE_TIME DESC)
select (select count(1) from temp) total_row, temp.* from temp where rownum = 1 union all
select * from (select rownum total_row,temp.* from temp where rownum <= {2}) where total_row > {1})", strWhere, (pageindex - 1) * pagesize, pageindex * pagesize);

转载于:https://www.cnblogs.com/qbq01/p/6951276.html