Ansicht
Dokumentation

ABENCDS_SELECT_CLAUSES - CDS SELECT CLAUSES

- SELECT, clauses

... $[WHERE cond_expr$]
    $[GROUP BY field1, field2, ...$]
    $[HAVING cond_expr$]
    $[UNION $[ALL$] SELECT ...$] ...

Effect

The optional clauses of the SELECT statement of a CDS view have the following semantics:

• The WHERE clause restricts the rows in the result set when the CDS view is accessed.

• The GROUP BY clause groups rows in the result set when the CDS view is accessed. It is applied after rows are selected using the WHERE clause.

• The HAVING clause restricts the result set further after a GROUP BY clause. Here, aggregate expressions can be specified in the condition.

• UNION can be used to create the union of the result sets from two SELECT statements.