请教EXCEPT排序的问题

[defent]

(SELECT top 300 id,name FROM price order by id desc) except (SELECT top 270 id,name FROM price order by id desc)

没有用过EXCEPT，因为想用它分页，不知道怎么用，请大神帮忙

[吉普赛的歌]

分页现在基本是固定的几种方式， 各种效率都测试过了， 不需要再另外自己造轮子：

--SQL Server 2005, 2008 的分页
SELECT * FROM (
	SELECT ROW_NUMBER() OVER (ORDER BY sv.number) AS rid,*
	FROM [master].dbo.spt_values AS sv 
	WHERE sv.[type]='P' AND sv.number>0
) AS t WHERE t.rid>270 AND t.rid<=300

--SQL Server 2012+ 的分页
SELECT *
FROM [master].dbo.spt_values AS sv 
WHERE sv.[type]='P' AND sv.number>0
ORDER BY sv.number
OFFSET 270 ROWS 
FETCH NEXT 30 ROWS ONLY

[二月十六]

SELECT *
FROM
(
    (SELECT TOP 300
         id,
         name
     FROM price
     ORDER BY id DESC)
    EXCEPT
    (SELECT TOP 270
         id,
         name
     FROM price
     ORDER BY id DESC)
) t
ORDER BY id DESC;

[OwenZeng_DBA]

引用 楼主 defent 的回复:

(SELECT top 300 id,name FROM price order by id desc) except (SELECT top 270 id,name FROM price order by id desc) 没有用过EXCEPT，因为想用它分页，不知道怎么用，请大神帮忙

用EXCEPT分页？他不是用来分页的啊