1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

Multiple CTE in single query

Discussão em 'Outras Linguagens' iniciado por Stack, Maio 28, 2021.

  1. Stack

    Stack Membro Participativo

    Is it possible to combine multiple CTEs in single query with arel? I am looking for way to get result like this:

    WITH 'cte1' AS (
    ...
    ),
    WITH RECURSIVE 'cte2' AS (
    ...
    ),
    WITH 'cte3' AS (
    ...
    )
    SELECT ... FROM 'cte3' WHERE ...


    As you can see, I have one recursive CTE and two non recursive.

    Continue reading...
    Stack, Maio 28, 2021
    #1

Compartilhe esta Página