Page Comparison

WITH VehicleMakes AS(SELECT distinct make,ROW_NUMBER() OVER (ORDER BY make) AS RowNumber 
FROM Vehicles where make like '%{{ query.lookupitem }}%') SELECT make, RowNumber FROM VehicleMakes 
WHERE RowNumber BETWEEN {{ query.skip }} + 1 AND {{ query.limit }} + {{ query.skip }};