Expressions in
Group By
①
BigQuery
Db2 (LUW)
DuckDB
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2013
2015
2017
2019
2021
2023
2025
3.21.0 - 3.51.0
2017 - 2025
10 - 18
18c - 23.26.1
8.0.11 - 9.6.0
a
10.3 - 12.2.2
1.4.192 - 2.4.240
1.0.0 - 1.4.0
11.1 - 12.1.3
2.0
a
Only if the complete
select
entry equals the
group by
entry. I.e. not:
SELECT a
+ b
FROM ... GROUP BY a, b