2 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.