sql分页
use [New_BeiJingGuoMaoGame_www.bjifeicuiedu.com_1_new]
go
with list as(
SELECT ROW_NUMBER() OVER(order by Id) AS num,*
FROM dbo.FcArticle
)
select * from list
where num between 51 and 100
select top 100 * from dbo.FcArticle order by Id