diff options
Diffstat (limited to 'content/posts/postgres-aggregates/aggregation.sql')
| -rw-r--r-- | content/posts/postgres-aggregates/aggregation.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/content/posts/postgres-aggregates/aggregation.sql b/content/posts/postgres-aggregates/aggregation.sql index ebb9ed5..32b08ab 100644 --- a/content/posts/postgres-aggregates/aggregation.sql +++ b/content/posts/postgres-aggregates/aggregation.sql @@ -14,7 +14,7 @@ FROM LEFT JOIN reviews ON reviews.product_id = products.id LEFT JOIN orders ON orders.product_id = products.id -- WHERE - -- products.id % 10 = 0 + -- products.name ilike '%0' GROUP BY products.id; |