Sql中无视Id的排序

做个笔记方便自己使用

select * from(select ROW_NUMBER() over(order by id) as 'rowNumber', * from [Table])  as rowczfyw  where rowNumber between ((@limit*(@page-1))+1) and ((@limit * @page))

我这里是结合Dapper写的，看不懂的等日后更新补充\

sqlserver