Versions Compared


    • This line was added.
    • This line was removed.
    • Formatting was changed.
    Comment: Published by Scroll Versions from this space and version 20.6

    ADQL Query Syntax

    ADQL uses the SELECT statement combined with filtering statements to return sets of data, which can optionally be visualized and added to Custom Dashboards. These ADQL statements are referred to as queries.

    ADQL search queries have a 5k character limit. The query syntax is as follows: 

    SELECT * | {[DISTINCT] expression [AS alias] [, expression [AS alias]]...}

    FROM event_type

    [WHERE condition_expression] 

    [SINCE timevalue [UNTIL timevalue]]

    [HAVING condition_expression]

    [ORDER BY {field_name | alias} [ASC | DESC] [, {field_name | alias} [ASC | DESC]]...]

    [LIMIT integer [, integer]...]

    The SELECT clause and FROM clause are required. All other clauses are optional. Type spaces around each keyword.

    For GROUP BY functionality, see GROUP BY.