common-table-expression

185 Questions
Newest Active Unanswered Frequent
Score
View
Card Compact
Join on recursive CTE in snowflake disobeys where clause
user_173780040
•
2
1
173
snowflake-cloud-data-platform common-table-expression
PostgreSQL: use column as ARRAY in a WITH construction
user_140995550
•
1
1
39
common-table-expression postgresql arrays
PostgreSQL query for determining cohorts of data by timestamp and name
user_35968550
•
2
1
44
common-table-expression postgresql sql
Selecting values from a nested column based on a condition applied to another nested column in BigQuery
user_159219410
•
2
1
490
google-bigquery common-table-expression sql
Conditional logic based on two datasets in SQL/Snowflake
user_93932180
•
2
2
63
snowflake-cloud-data-platform common-table-expression sql
Why are scans of CTEs and temporary tablest parallel restricted?
user_29850950
•
1
2
126
postgresql-14 parallel-processing common-table-expression postgresql
SQL: Build table of numbers up to a variable input number inside CTE
user_31587390
•
2
1
100
snowflake-cloud-data-platform common-table-expression sql
Dynamic SQL with EXECUTE and nested format()
user_97969350
•
1
2
303
dynamic-sql plpgsql common-table-expression postgresql
How to conditionally UPDATE/INSERT after DELETE that doesn't find rows?
user_29195440
•
2
2
134
common-table-expression postgresql sql json
Snowflake, Recursive CTE , Getting error String 'AAAA_50>BBBB_47>CCCC_92' is too long and would be truncated in 'CONCAT'
user_149359940
•
2
1
134
snowflake-cloud-data-platform recursion common-table-expression
Hot Questions