DECLARE @startNum int;
DECLARE @endNum int;
SET @startNum =1;
SET @endNum =10;
SELECT * FROM (
SELECT row_number() OVER (ORDER BY a.userid) as RowNumber,* FROM user_tbl a
) temp WHERE RowNumber BETWEEN @startNum And @endNum
sqlserver 简单分页
最新推荐文章于 2024-05-24 11:13:20 发布