ADQL Reference:

Your Rating:
17 rates

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.

ADQL statements are referred to as queries. 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.


  • No labels