MS SQL運用ROW NUMBER耶得區間資料

select * from (
SELECT ROW_NUMBER() OVER(ORDER BY seq DESC) AS Row,
    Material_Cname,lot
FROM Y
) xyz where Row between 100 and 200