Clauses supported by the
SELECT
 statement

  • FROM
    IMPORTANT:
    Subqueries are allowed for the
    FROM
     and for the
    IN
     predicate.
    The
    FROM
     clause is required, other clauses are optional.
    The clauses must have the following order:
    FROM
    ,
    WHERE
    ,
    GROUP
    ,
    HAVING
    ,
    ORDER
    ,
    LIMIT
    .
  • JOIN
  • AS
     (alias for tables and columns, allows
    regular
     and
    delimited
     identifiers)
  • WHERE
  • GROUP BY
  • ORDER BY
  • Set function (
    COUNT
    ,
    MAX
    ,
    MIN
    ,
    AVG
    ,
    SUM
    )
  • HAVING
  • LIMIT
    TIP:
    You can use the
    LIMIT OFFSET
     variant to limit the number of records. The offset is optional and its default value is
    0
    .
    For example,
    SELECT * FROM Table1 LIMIT 1000 OFFSET 10
     returns 1000 records starting from the record number 10.
Provide Feedback
Have questions or feedback about this documentation? Please submit your feedback here.