ROW_NUMBER() 简单的分页

      select * from (
      select *,ROW_NUMBER() OVER(ORDER BY UserID DESC) as RowID from h_userinfo where isdelete=0
      ) as c where RowID between #StarRow# and #EndRow#

SELECT * FROM
	 (
	  SELECT *, ROW_NUMBER() over( ORDER BY [ID] desc)as RowID FROM [dbo].[consumer]
	  where 1=1 and isDetele=0  
	 ) as A where RowID between 1 and 10