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