Clauses supported by the
SELECT
 statement

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