## Syntax ```mermaid %%{init: { 'theme': 'base', 'flowchart': { 'padding': '7', 'nodeSpacing': '20', 'rankSpacing': '20' }, 'themeVariables': { 'fontSize': '11px', 'fontFamily': 'Arial' } }}%% flowchart LR embeddedSelect_start((START)) embeddedSelect_start --> embeddedSelect_0_0["("]:::quoted embeddedSelect_0_0 --> embeddedSelect_0_1[<a href="Invantive UniversalSQL/Grammar/Query Statement/Select Statement#selectStatement" class="internal-link">selectStatement</a>] embeddedSelect_0_1 --> embeddedSelect_0_2[")"]:::quoted embeddedSelect_0_2 --> embeddedSelect_end((END)) ``` ## Purpose An embedded select, also known as an 'inline view', retrieves rows using the specified select statement. These rows are consumed by the outer select as were it the results of retrieving the rows from a table. Invantive UniversalSQL does not allow grouping rows with expressions as columns. An embedded select is typically used to evaluate expressions to rows with solely constants. After applying the embedded select the group operators can be applied.