declare @pagesize int--每页大小 declare @currentpage int--当前页 set @pagesize=2 set @currentpage=2 SELECT TOP (@pagesize) * FROM ( SELECT top(@pagesize*@currentpage) ROW_NUMBER() OVER (ORDER BY XingMBianH ) AS Num,XingMBianH FROM TJ_HT_XiangMu order by Num ) as t WHERE t.Num > (@pagesize*(@currentpage-1)) order by t.Num;