摘要：T-SQL语句：select * from (select row_number() over(order by id) as idx, T_A.* from T_A) as T_B where T_B.idx between (PageNum-1)*PageCount and (PageNum-1)*PageCounteg:select * from (select ROW_NUMBER() over(order by ID) as idx,dbo.客户.* from dbo.客户) as b where b.idx between 1*10 and 2*10 阅读全文