Get Range wise data from sql table

select *

FROM

(SELECT ROW_NUMBER() OVER(ORDER BY pk_OrganizationId DESC) as RowNum,*

FROM Organization) data

WHERE data.RowNum >= 3 AND data.RowNum <= 6