您的位置: 首页  >  IT文章  >  SQL 数据库分页语句

SQL 数据库分页语句

分类: IT文章 • 2022-06-02 16:12:31 
declare @pagesize integer,@cpage integer;
set @pagesize =500;
set @cpage = 1;

SELECT TOP (@pagesize) * FROM 
     (SELECT row_number() over(order by MemberID) as row_number,* FROM (SELECT * FROM Member WHERE 1=1 ) Temp ) TEMPTABLE  
WHERE 1=1 AND row_number 
NOT IN(
SELECT TOP ((@cpage - 1) * @pagesize) row_number FROM 
      (SELECT row_number() over(order by MemberID) as row_number,* FROM (SELECT * FROM Member WHERE 1=1 ) Temp ) TEMPTABLE  
    WHERE 1=1 ORDER BY row_number ASC 
) ORDER BY row_number ASC;

相关推荐