Skip to content

WITH clause

Jump to bottom
Marijn van Wezel edited this page Jan 1, 2023 · 3 revisions

The WITH clause allows query parts to be chained together, piping the results from one to be used as starting points or criteria in the next.

Query::with(Alias|AnyType|bool|float|int|mixed[]|Pattern|string|(Alias|AnyType|bool|float|int|mixed[]|Pattern|string)[] $expressions): Query

Parameters

  • $expressions : An entry to add, or a non-empty list of entries to add; if the array-key is non-numerical, it is used as the alias.

Relevant methods

  • addEntry(Alias|Pattern|string|Variable ...$entries): self : Add one or more new entries to the WITH clause.

External links

  1. Installation
  2. Usage
    1. Clauses
      1. CALL {} (subquery)
      2. CALL procedure
      3. CREATE
      4. DELETE
      5. LIMIT
      6. MATCH
      7. MERGE
      8. OPTIONAL MATCH
      9. ORDER BY
      10. REMOVE
      11. RETURN
      12. SET
      13. SKIP
      14. UNION
      15. WHERE
      16. WITH
      17. Raw clause
    2. Expressions
    3. Procedures
    4. Literals
    5. Parameters
    6. Examples
Clone this wiki locally