diff options
Diffstat (limited to 'content/posts/postgres-aggregates/sequential-ctes.sql')
| -rw-r--r-- | content/posts/postgres-aggregates/sequential-ctes.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/content/posts/postgres-aggregates/sequential-ctes.sql b/content/posts/postgres-aggregates/sequential-ctes.sql index fa18acd..825649e 100644 --- a/content/posts/postgres-aggregates/sequential-ctes.sql +++ b/content/posts/postgres-aggregates/sequential-ctes.sql @@ -8,7 +8,7 @@ WITH product_with_reviews AS ( products LEFT JOIN reviews ON reviews.product_id = products.id -- WHERE - -- products.id % 10 = 0 + -- products.name ilike '%0' GROUP BY products.id, products.name |