摘要:
1 --分页查询,要求表必须包含标识列 2 SELECT [要查询字段] 3 FROM [查询表名称], 4 ( 5 SELECT * 6 FROM 7 ( 8 SELECT ROW_NUMBER() OVER(ORDER BY [排序字段]) as F_ID,[表标识列名称] AS F_ID_0 9 FROM [查询表名称] 10 WHERE [查询条件]11 ) AS [全部查询结果] 12 WHERE [全部查询结果].F_ID>=[分页记录开始号码] AND [全部查询结果].F_ID<[分... 阅读全文