expressions ⓷
BigQuery
Db2 (LUW)
DuckDB
H2
MariaDB
MySQL
Oracle DB
PostgreSQL
SQL Server
SQLite
2008
2010
2012
2014
2016
2018
2020
2022
2024
⊘ 3.5.7 - 3.53.0
⊘ 2008R2 - 2025
⚠ 8.3 - 18
a
✓ 12cR1 - 23.26.1
✓ 5.7 - 9.7.0
⊘ 5.0 - 5.6
✓ 10.1 - 12.2.2
⊘ 5.1 - 10.0.10
⚠ 1.4.191 - 2.4.240
a
✓ 1.0.0 - 1.5.0
✓ 9.7 - 12.1.4
✓ 2.0+
Expressions cannot contain selected names:
select c
AS x
FROM (VALUES (1), (2)) t(c) ORDER BY
x