Markus Winand personal blog
The SQL filter clause: selective aggregates
The FILTER clause extends aggregate functions (SUM, AVG, COUNT, etc.) with an additional WHERE clause. Databases not supporting FILTER can use CASE within the aggregate function instead.
- Points
- 138
- HN comments
- 47
- Submissions
- 1
- Cited by
- 3 commenters
Databases & DataSoftware Engineering2016
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| May 30, 2016 | The SQL filter clause: selective aggregates by MarkusWinand | 138 | 47 |
Cited in comments
Linked from 3 Hacker News comments by 3 different people, from Apr 2017 to Feb 2023.
Most recent:
- zX41ZdbW · Feb 10, 2023
- orf · Feb 3, 2018
- MarkusWinand · Apr 6, 2017
