1、sqlserver数据库分页是特殊的。也会有多种,记录下自己常用的一种。直接上代码,查询0-20页数据 ,sql如下
select top 20 * from (select *, ROW_NUMBER() over(Order by name) AS RowNumber from myTable
) as b where RowNumber>0
1、sqlserver数据库分页是特殊的。也会有多种,记录下自己常用的一种。直接上代码,查询0-20页数据 ,sql如下
select top 20 * from (select *, ROW_NUMBER() over(Order by name) AS RowNumber from myTable
) as b where RowNumber>0