[/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 sets helper functions (navtitle][/map/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Grouping sets helper functions (linktext][/map/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) There are three helper functions that you can use for queries that use grouping capabilities. (shortdesc] (topicmeta][/map/topicref/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) GROUPING function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext {"- map/linktext "}) GROUPING function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) GROUPING indicates whether a specified attribute expression in a GROUP BY list is aggregated. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) GROUPING_ID function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext {"- map/linktext "}) GROUPING_ID function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The GROUPING_ID function computes the GROUP BY level of a particular row. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) GROUP_ID function (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext {"- map/linktext "}) GROUP_ID function (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) The GROUP_ID function uniquely identifies a group of rows that has been created by a GROUP BY clause in the query result set. (shortdesc] (topicmeta] (topicref][/map/topicref/topicref/topicref {"- map/topicref "}) [/map/topicref/topicref/topicref/topicmeta {"- map/topicmeta "}) [/map/topicref/topicref/topicref/topicmeta/navtitle {"- topic/navtitle "}) Notes on grouping behavior (navtitle][/map/topicref/topicref/topicref/topicmeta/linktext {"- map/linktext "}) Notes on grouping behavior (linktext][/map/topicref/topicref/topicref/topicmeta/shortdesc {"- map/shortdesc "}) This topic describes some EQL grouping behaviors that you should be aware of. (shortdesc] (topicmeta] (topicref] (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 "}) 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 "}) 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.集計関数フィルタは、集計式の入力をフィルタリングします。これが役に立つのは、スパースまたは異種混在のデータを扱うときです。Only records that satisfy the filter contribute to the calculation of the aggregation function. (shortdesc] (topicmeta] (topicref] (topicref] (map]