SELECT *,COUNT(1) OVER() AS TotalItemCountFROM Positions WHERE 1=1 ORDER BY id DESCOFFSET 1 ROW FETCH NEXT 5 ROWS ONLY