Learn about the different query forms supported in Pivotal GemFire XD.
Create a virtual table based on existing tables or constants built into tables.
You can place a ScalarSubquery anywhere an Expression is permitted. A ScalarSubquery turns a SelectExpression result into a scalar value because it returns only a single row and column value.
A TableSubquery is a subquery that returns multiple rows.