Waiting for SQL:202y: Group by All
12 days ago
- #SQL
- #Database
- #Programming
- GROUP BY ALL simplifies SQL queries by automatically grouping by non-aggregate columns.
- The SQL standard working group has accepted GROUP BY ALL, with formal specifications pending.
- GROUP BY ALL expands to non-aggregate select list elements but doesn't handle complex expressions.
- Potential risks include unintended query changes when modifying select lists.
- Oracle Database and PostgreSQL have implemented GROUP BY ALL, with PostgreSQL's release pending.