SQL Server简洁分页代码
declare @page int = 3,@rowCount int = 5;
select * from(
select ROW_NUMBER() over(order by IUID asc) Id,* from T_TABLE1 where 1 = 1
) t
where Id between (@page - 1) * @rowCount and @page * @rowCount;
SQL Server简洁分页代码
declare @page int = 3,@rowCount int = 5;
select * from