怎么倒序输出id行号

[富坚老贼你更啊]

int pageSize=30; //一页显示多少条记录
int pageNow=1; //默认显示第一页
int rowCount=0; //该值从数据库查询 总条数
int pageCount=0; //一共多少页

"select top "+pageSize+" * from pc_taizhang where id not in(select top "+pageSize*(pageNow-1)+" id from pc_taizhang) ";
这个SQL语句是按id号顺序输出每一行，求教一下倒序输出该怎么写

[spiritofdragon]

子查询括号里最后要加order by id desc 外层 最后也要加 order by id desc

[中国风]

你那是SQL2000时的分页方法比较效，改成这样 SELECT * FROM (SELECT * ,RN=ROW_NUMBER()OVER(ORDER BY ID)FROM pc_taizhang) AS a WHERE RN BETWEEN "+pageSize*(pageNow-1)+1+" AND "+pageSize*pageNow+"

[中国风]

倒序这样用 "select top "+pageSize+" * from pc_taizhang where id not in(select top "+pageSize*(pageNow-1)+" id from pc_taizhang ORDER BY id DESC) ORDER BY id DESC"; SELECT * FROM (SELECT * ,RN=ROW_NUMBER()OVER(ORDER BY ID DESC)FROM pc_taizhang) AS a WHERE RN BETWEEN "+pageSize*(pageNow-1)+1+" AND "+pageSize*pageNow+"

[RICHEER COCA]

引用 3 楼 roy_88 的回复:

倒序这样用 "select top "+pageSize+" * from pc_taizhang where id not in(select top "+pageSize*(pageNow-1)+" id from pc_taizhang ORDER BY id DESC) ORDER BY id DESC"; SELECT * FROM (SELECT * ,RN=ROW_NUMBER()OVER(ORDER BY ID DESC)FROM pc_taizhang) AS a WHERE RN BETWEEN "+pageSize*(pageNow-1)+1+" AND "+pageSize*pageNow+"

学习了，正解！！

[道玄希言]

2012 或以上版本, 可以这么写

declare @pageSize int
declare @pageNow int
set  @pageSize = 10
set @pageNow = 2
select * 
from pc_taizhang
order by id desc offset @pageNow * @pageSize rows fetch next @pageSize rows only