SQL Dialects Reference/Select queries/Subqueries
Jump to navigation
Jump to search
Subqueries in FROM clause[edit | edit source]
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 |
|
MSSQL |
|
MySQL | ? |
Oracle | SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) WHERE conditions |
PostgreSQL |
|
SQLite |
|
Virtuoso | ? |