Clauses supported by the
SELECT
statement

  • FROM
    IMPORTANT:
    You can also use subqueries allowed for the
    FROM
    clause and for the
    IN
    predicate.
    You must use the
    FROM
    clause, the 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.