左正

摘要： 代码如下: declare @PageNumber int declare @PageSize int set @PageNumber=2 set @PageSize=20 --利用between select * from ( select row_number() over (order by source_ip,id) as row_num, * from tb) as page_table where row_num between (@PageNumber - 1) * @PageSize + 1 and @Pag... 阅读全文