SQL 语句--用于实现分页

1.row_number() over() as

 

select Oid from
(
select Oid, ROW_NUMBER() OVER (order by CreatedOn) as Pos from JY_Ting
) as T
where T.Pos > 10 and T.Pos < 20

2.(not in &&select top)

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id))
ORDER BY ID

 

3.(ID> &&select top)

SELECT TOP 页大小 *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 页大小*页数 id
FROM 表
ORDER BY id) AS T))
ORDER BY ID