This chapter 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.
SELECT clauses
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 clauses
You can include a FROM clause in your statement to specify a different record source from the result of the containing search and navigation query.
JOIN clauses JOIN clauses allow records from multiple statements to be combined, based on a relationship between certain attributes in these statements.
WHERE clauses
The WHERE clause is used to filter input records for an expression.
HAVING clauses
The HAVING clause is used to filter output records.
ORDER BY clauses
The ORDER BY clause is used to control the order of result records.
PAGE clauses
The PAGE clause specifies a subset of records to return.