SQL Dialects Reference/Select queries/Subqueries

Subqueries in FROM clause Subquery (ANSI calls it <derived table>) alias is mandatory:https://jakewheat.github.io/sql-overview/sql-2011-foundation-grammar.html#table-primary SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) [ AS ] subquery_alias WHERE conditions ? ? ? ? ? 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 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 SELECT expressions FROM (SELECT subquery expressions FROM subquery tables) WHERE conditions 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 SELECT … FROM (SELECT …) [AS alias] WHERE … WITH cte AS (SELECT …) SELECT … FROM cte WHERE …