Subquery Categories

Subqueries generally fall into one of the following categories based on their structure and purpose:

  • Filter Query

    A filter query is a combination of syntax or functions that only filter the event set or modify values as part of the processing. It typically does not include aggregating functions.

  • Non-aggregate Query

    Any query that does not include an aggregate function.

  • Aggregate Query

    A query that explicitly includes aggregating functions to produce an aggregate event set.