company logo

Optional select functions

Several optional clauses can be defined in a select statement as WHERE, HAVING for pre- and post selection, GROUP_BY for aggregation and ORDER_BY for ordering in a special way.

Definition: 

sel_extensions := from_spec | where_spec | having_spec | group_spec | order_spec

Subtopics

  1. from - FROM operands
  2. where - Where specification
  3. group - Group operands
  4. having - Having specification
  5. order - Order specification
  6. Aggregation options