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 ]