...
Code Block | ||
---|---|---|
| ||
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 }}; |
...