select
top
10
*
from
(
select
top
30
*
,ROW_NUMBER()
over
(
order
by
readerid
desc
)
as
rows1
from
reader )
as
a1
where
rows1
>=
21
转载于:https://www.cnblogs.com/a12-3/archive/2010/07/17/1779365.html