Hi, is there a way to select a row range from query of query. I mean like an alternative for LIMIT and OFFSET in regular MySQL queries.
Query of query doesn't have that. Nevertheless, if your query had a numerically ordered column, then you could filter using a clause like:
where productId between 27 and 89
Depending on the underlying database you are using it is possible. In SQL Server, and I think My SQL, you can use the ROW_NUMBER() function to generate an incrementing sequence number for each row in the result set.
<cfquery name="q" datasource="DSN">
SELECT col1, col2,
ROW_NUMBER() OVER (ORDER BY col1) AS rownum
<cfquery name="qq" dbtype="query">
SELECT col1, col2, rownum
where rownum between 20 and 30