Selecting a row range from query of queries

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
FROM myTable
</cfquery>

<cfquery name="qq" dbtype="query">
SELECT col1, col2, rownum
from q
where rownum between 20 and 30
</cfquery>

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 

According to the QoQ Help page, no.

V/r,

^ _ ^