Author: SSWUG Research

Community

State of the UNION

(Norvald H. Ryeng) Since union queries were introduced in MySQL 4.0.0, they have been processed by executing each part of the union and adding the result to a temporary table. Then a final query block is executed that, if needed, filters out duplicates, do global ordering and limit the number of out

Community

Nesting Levels in SQL

(Joe Celko) The ‘Structured’ part of SQL denotes the fact that queries can be nested inside each other in such a way that, wherever you can use a table, you can use a table expression. Such derived tables can provide powerful magic, to which is added CTEs and Lateral Tables.