| Standard
|
Subquery (ANSI calls it <derived table>) alias is mandatory:[1]
SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) [ AS ] subquery_alias WHERE conditions
|
| DB2
|
?
|
| Firebird
|
?
|
| Ingres
|
?
|
| Linter
|
?
|
| MonetDB
|
- SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) [ AS ] subquery_alias WHERE conditions
- Subquery alias is mandatory
- WITH common_table_expression AS (SELECT subquery expressions FROM subquery tables) SELECT expressions FROM common_table_expression WHERE conditions
|
| MSSQL
|
- SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) [ AS ] subquery_alias WHERE conditions
- Subquery alias is mandatory
- WITH common_table_expression AS (SELECT subquery expressions FROM subquery tables) SELECT expressions FROM common_table_expression WHERE conditions
|
| MySQL
|
?
|
| Oracle
|
SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) WHERE conditions
|
| PostgreSQL
|
- SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) [ AS ] subquery_alias WHERE conditions
- Subquery alias is mandatory
- WITH common_table_expression AS (SELECT subquery expressions FROM subquery tables) SELECT expressions FROM common_table_expression WHERE conditions
|
| SQLite
|
- SELECT … FROM (SELECT …) [AS alias] WHERE …
- WITH cte AS (SELECT …) SELECT … FROM cte WHERE …
|
| Virtuoso
|
?
|
