Details
-
Improvement
-
Resolution: Duplicate
-
Major
-
Mad Hatter
-
None
-
1
Description
We have added common table expression to the N1QL grammar.
Common Table Expression allows to assign an expression to a variable for subsequent use in a select statement. Sort of like LET, but prior to the select, and not after FROM.
Looks like this:
WITH <variable name> AS
(
any expression or select statement
) [, <variable name> AS (....)]
SELECT ... variable ....
Attachments
Issue Links
- is duplicated by
-
DOC-4464 Document Common Table Expression
- Resolved