SQL server Paging

select * from
( SELECT   ROW_NUMBER() OVER (ORDER BY uniqueid) as ROW , * from TableName where status = 2 ) as a
where ROW BETWEEN 1 and 10