--第一页
select top 8 * from tb order by sort
--第二页
select top 8 * from tb
where sort not in ( select top 8 sort from tb order by sort)
order by sort--第N页
select top 8 * from tb
where sort not in ( select top 8*(N-1) sort from tb order by sort)
order by sort
INSERT INTO #TAB VALUES('王三' , 1)
INSERT INTO #TAB VALUES('王三' , 2)
INSERT INTO #TAB VALUES('王三' , 3)
INSERT INTO #TAB VALUES('王三' , 5)
INSERT INTO #TAB VALUES('王三' , 8)
INSERT INTO #TAB VALUES('王三' , 9)
INSERT INTO #TAB VALUES('王三' , 12)
INSERT INTO #TAB VALUES('王三' , 24)
INSERT INTO #TAB VALUES('王三' , 50)
INSERT INTO #TAB VALUES('李四' , 25)
INSERT INTO #TAB VALUES('李四' , 32)
SELECT
A.*,A.CNT%8 AS CNT1
FROM
(SELECT
ROW_NUMBER() OVER(PARTITION BY NAM ORDER BY NAM,SORT) AS CNT,
NAM,
SORT
FROM
#TAB
) A
ORDER BY A.NAM,A.SORT1 王三 1 1
2 王三 2 2
3 王三 3 3
4 王三 5 4
5 王三 8 5
6 王三 9 6
7 王三 12 7
8 王三 24 0
9 王三 50 1
1 李四 25 1
2 李四 32 2是不是這個意思