Selecting a row range from query of queries

[riteshl80338356]

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.

[WolfShade]

According to the QoQ Help page, no.

V/r,

^ _ ^

[BKBK]

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 

[John123]

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>