摘要:
declare @pagenum int = 1;declare @pagesize int = 3;WITH Tmp AS ( SELECT ROW_NUMBER() OVER (ORDER BY uid ASC) AS colnum, uid, uname FROM dbo.users o1)SELECT uid,uname FROM TmpWHERE colnum>(@pagenum-1)*@pagesize AND colnum<=@pagenum*@pagesize; 阅读全文