[/map
{"- map/map "})
[/map/title
{"- topic/title "}) Aggregation (title][/map/topicref
{"- map/topicref "}) [/map/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Aggregation (navtitle][/map/topicref/topicmeta/linktext
{"- map/linktext "}) Aggregation (linktext][/map/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) In EQL, aggregation operations bucket a set of records into a resulting set of aggregated records. (shortdesc] (topicmeta][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) GROUP/GROUP BY clauses (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) GROUP/GROUP BY clauses (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The GROUP and GROUP BY clauses specify how to map source records to result records in order to group statement output. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) MEMBERS extension (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) MEMBERS extension (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) MEMBERS is an extension to GROUP BY that allows grouping by the members of a set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) GROUPING SETS expression (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) GROUPING SETS expression (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) A GROUPING SETS expression allows you to selectively specify the set of groups that you want to create within a GROUP BY clause. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) ROLLUP extension (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) ROLLUP extension (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) ROLLUP is an extension to GROUP BY that enables calculation of multiple levels of subtotals across a specified group of attributes. It also calculates a grand total. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) CUBE extension (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) CUBE extension (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) CUBE takes a specified set of attributes and creates subtotals for all of their possible combinations. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) GROUPING function (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) GROUPING function (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The GROUPING helper function indicates whether a specified attribute expression in a GROUP BY list is aggregated. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) COUNT function (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) COUNT function (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The COUNT function returns the number of records that have a value for an attribute. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) COUNT_APPROX (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) COUNT_APPROX (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) COUNT_APPROX returns the most frequent refinements. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) COUNTDISTINCT function (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) COUNTDISTINCT function (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The COUNTDISTINCT function counts the number of distinct values for an attribute. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) APPROXCOUNTDISTINCT function (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) APPROXCOUNTDISTINCT function (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) The APPROXCOUNTDISTINCT function counts the number of distinct values for an attribute. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Multi-level aggregation (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Multi-level aggregation (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) You can perform multi-level aggregation in EQL. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref
{"- map/topicref "}) [/map/topicref/topicref/topicmeta
{"- map/topicmeta "}) [/map/topicref/topicref/topicmeta/navtitle
{"- topic/navtitle "}) Per-aggregation filters (navtitle][/map/topicref/topicref/topicmeta/linktext
{"- map/linktext "}) Per-aggregation filters (linktext][/map/topicref/topicref/topicmeta/shortdesc
{"- map/shortdesc "}) Each aggregation can have its own filtering WHERE clause. Aggregation function filters filter the inputs to an aggregation expression. They are useful for working with sparse or heterogeneous data. Only records that satisfy the filter contribute to the calculation of the aggregation function. (shortdesc] (topicmeta] (topicref] (topicref]
(map]