Use CTE value for query offset #282
Unanswered
ShawnToubeau
asked this question in
Q&A
Replies: 1 comment 2 replies
-
Hi @ShawnToubeau , As a workaround, you can use a
https://github.com/go-jet/jet/wiki/Subquery#what-if-sub-query-projection-is-not-a-table-column |
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Hi all!
I'm trying to use build a Jet equivalent query of this SQL
Here I'm using a subquery in the CTE to get all records and their row number in table
completion
. The CTE then selects the exact record + row number I want. In my main query I then use the row number of that record as the offset.Here's my attempt at a Jet query but I can't figure out how to use the CTE in the offset.
I looked through the wiki and the Jet code for similar examples but I didn't see anything. Thanks :)
Beta Was this translation helpful? Give feedback.
All reactions