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.