Highlighted

Selecting a row range from query of queries

New Here ,
Oct 14, 2019

Copy link to clipboard

Copied

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.

Views

104

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

Selecting a row range from query of queries

New Here ,
Oct 14, 2019

Copy link to clipboard

Copied

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.

Views

105

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Oct 14, 2019 0
LEGEND ,
Oct 15, 2019

Copy link to clipboard

Copied

According to the QoQ Help page, no.

 

V/r,

 

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 15, 2019 0
Adobe Community Professional ,
Oct 16, 2019

Copy link to clipboard

Copied

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 

 

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 16, 2019 0
John123 LATEST
Participant ,
Oct 16, 2019

Copy link to clipboard

Copied

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>

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Oct 16, 2019 0