Statements and Clauses

This section describes the types of clauses used in EQL statements.

For information on the GROUP and GROUP BY clauses, see Aggregation.

DEFINE clause
DEFINE is used to generate an intermediate result that will not be included in the query result.
RETURN clause
RETURN indicates that the statement result should be included in the query result.
LET clause
The LET clause defines attributes that may be used elsewhere in the statement but do not necessarily appear in the statement's result.
SELECT clause
The SELECT clause defines the list of attributes on the records produced by the statement.
AS clause
The AS clause allows you to give an alias name to EQL attributes and results.
FROM clause
You must include a FROM clause in your statement to specify a record source.
JOIN clause
JOIN clauses allow records from multiple statements and/or named states to be combined, based on a relationship between certain attributes in these statements.
WHERE clause
The WHERE clause is used to filter input records for an expression.
HAVING clause
The HAVING clause is used to filter output records.
ORDER BY clause
The ORDER BY clause is used to control the order of result records.
PAGE clause
The PAGE clause specifies a subset of records to return.