Statement

Select-Statement

Abbilden einer SELECT-Abfrage an eine relationale Datenbank mit Unterstützung von SQL2011.

$statement = new SelectStatement('SELECT a FROM b WHERE c');

SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ] expression [ <![AS]> name ] [,...] [ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ] [ FROM {table | (select query)} [ alias ] [,...] ] [ {{LEFT | RIGHT} [OUTER] | NATURAL |[FULL] OUTER} JOIN table alias {ON condition | USING(col1,col2,...)} ] [ WHERE {condition | EXISTS (correlated subquery)} ] [ GROUP BY column [,...] ] [ HAVING condition [,...] ] [ { UNION [ ALL ] | INTERSECT | EXCEPT | MINUS } select ] [ ORDER BY {column | int} [ ASC | DESC | USING operator ] [,...] ] [ FOR UPDATE [ OF class_name [,...] ] ] LIMIT { count | ALL } [ { OFFSET | ,} start ]