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
|
?
|
---|