SQL SELECTING ROWS BETWEEN FIRST AND LAST ROW

DECLARE @ID INT;
SELECT @ID=COUNT(*) FROM PRODUCTS;
SELECT *
from
(
   SELECT *, ROW_NUMBER() over (ORDER By PRODUCTID) rn
   FROM dbo.Products
) v
WHERE rn >1 AND RN <@ID;