我的书签
添加书签
移除书签聚合函数
源文档无正文。
原文：<https://www.bookstack.cn/read/doris-2.1-zh/SQL手册-SQL函数-聚合函数.md>
聚合函数
- 快速开始
- 安装部署
- 数据表设计
- 数据操作
- 进阶使用
- 查询加速
- 数据湖分析
- 生态扩展
- SQL 手册
- SQL 函数
- 数组函数
- ARRAY
- ARRAY_MAX
- ARRAY_MIN
- ARRAY_MAP
- ARRAY_FILTER
- ARRAY_AVG
- ARRAY_SUM
- ARRAY_SIZE
- ARRAY_REMOVE
- ARRAY_SLICE
- ARRAY_SORT
- ARRAY_REVERSE_SORT
- ARRAY_SORTBY
- ARRAY_POSITION
- ARRAY_CONTAINS
- ARRAY_EXCEPT
- ARRAY_PRODUCT
- ARRAY_INTERSECT
- ARRAY_RANGE
- ARRAY_DISTINCT
- ARRAY_DIFFERENCE
- ARRAY_UNION
- ARRAY_JOIN
- ARRAY_WITH_CONSTANT
- ARRAY_ENUMERATE
- ARRAY_ENUMERATE_UNIQ
- ARRAY_POPBACK
- ARRAY_POPFRONT
- ARRAY_PUSHFRONT
- ARRAY_PUSHBACK
- ARRAY_COMPACY
- ARRAY_CONCAT
- ARRAY_ZIP
- ARRAY_SHUFFLE
- ARRAY_CUM_SUM
- ARRAY_EXISTS
- ARRAY_FIRST_INDEX
- ARRAY_LAST_INDEX
- ARRAY_FIRST
- ARRAY_LAST
- ARRAYS_OVERLAP
- ARRAY_COUNT
- ARRAY_APPLY
- COUNTEQUAL
- ELEMENT_AT
- SEQUENCE
- 日期函数
- CONVERT_TZ
- CURDATE,CURRENT_DATE
- CURTIME,CURRENT_TIME
- CURRENT_TIMESTAMP
- LOCALTIME,LOCALTIMESTAMP
- NOW
- YEAR
- QUARTER
- MONTH
- DAY
- DAYOFYEAR
- DAYOFMONTH
- DAYOFWEEK
- WEEK
- WEEKDAY
- WEEKOFYEAR
- YEARWEEK
- DAYNAME
- MONTHNAME
- HOUR
- MINUTE
- SECOND
- FROM_DAYS
- LAST_DAY
- TO_MONDAY
- FROM_SECOND
- FROM_UNIXTIME
- UNIX_TIMESTAMP
- UTC_TIMESTAMP
- TO_DATE
- TO_DAYS
- TIME_TO_SEC
- SEC_TO_TIME
- EXTRACT
- MAKEDATE
- STR_TO_DATE
- TIME_ROUND
- TIMEDIFF
- TIMESTAMPADD
- TIMESTAMPDIFF
- DATE_ADD
- DATE_SUB
- DATE_TRUNC
- DATE_FORMAT
- DATEDIFF
- date_floor
- date_ceil
- MICROSECOND
- MICROSECONDS_ADD
- MICROSECONDS_DIFF
- MICROSECONDS_SUB
- MILLISECONDS_ADD
- MILLISECONDS_DIFF
- MILLISECONDS_SUB
- MINUTES_ADD
- MINUTES_DIFF
- MINUTES_SUB
- SECONDS_ADD
- SECONDS_DIFF
- SECONDS_SUB
- HOURS_ADD
- HOURS_DIFF
- HOURS_SUB
- DAYS_ADD
- DAYS_DIFF
- DAYS_SUB
- WEEKS_ADD
- WEEKS_DIFF
- WEEKS_SUB
- MONTHS_ADD
- MONTHS_DIFF
- MONTHS_SUB
- YEARS_ADD
- YEARS_DIFF
- YEARS_SUB
- 地理位置函数
- 字符串函数
- TO_BASE64
- FROM_BASE64
- ASCII
- LENGTH
- BIT_LENGTH
- CHAR_LENGTH
- LPAD
- RPAD
- LOWER
- LCASE
- UPPER
- UCASE
- INITCAP
- REPEAT
- REVERSE
- CHAR
- CONCAT
- CONCAT_WS
- SUBSTRING
- SUB_REPLACE
- APPEND_TRAILING_CHAR_IF_ABSENT
- ENDS_WITH
- STARTS_WITH
- TRIM
- LTRIM
- RTRIM
- NULL_OR_EMPTY
- NOT_NULL_OR_EMPTY
- HEX
- UNHEX
- ELT
- INSTR
- LOCATE
- FIELD
- FIND_IN_SET
- REPLACE
- STRLEFT
- STRRIGHT
- SPLIT_PART
- SPLIT_BY_STRING
- SUBSTRING_INDEX
- MONEY_FORMAT
- PARSE_URL
- url_decode
- CONVERT_TO
- EXTRACT_URL_PARAMETER
- UUID
- SPACE
- SLEEP
- ESQUERY
- random_bytes
- Search in String
- Mask in String
- 模糊匹配
- 正则匹配
- Struct Functions
- Combinators
- 聚合函数
- MIN
- MIN_BY
- MAX
- MAX_BY
- AVG
- AVG_WEIGHTED
- SUM
- STDDEV,STDDEV_POP
- STDDEV_SAMP
- VARIANCE,VAR_POP,VARIANCE_POP
- VAR_SAMP,VARIANCE_SAMP
- COVAR
- COVAR_SAMP
- CORR
- TOPN
- TOPN_ARRAY
- TOPN_WEIGHTED
- COUNT
- COUNT_BY_ENUM
- APPROX_COUNT_DISTINCT
- PERCENTILE
- PERCENTILE_ARRAY
- PERCENTILE_APPROX
- HISTOGRAM
- GROUP_BITMAP_XOR
- GROUP_BIT_AND
- GROUP_BIT_OR
- GROUP_BIT_XOR
- GROUP_CONCAT
- BITMAP_UNION
- HLL_UNION_AGG
- GROUPING
- GROUPING_ID
- ANY_VALUE
- ARRAY_AGG
- MAP_AGG
- BITMAP_AGG
- COLLECT_SET
- COLLECT_LIST
- RETENTION
- SEQUENCE_MATCH
- SEQUENCE_COUNT
- Bitmap 函数
- TO_BITMAP
- BITMAP_HASH
- BITMAP_FROM_STRING
- BITMAP_TO_STRING
- BITMAP_TO_ARRAY
- BITMAP_FROM_ARRAY
- BITMAP_EMPTY
- BITMAP_OR
- BITMAP_AND
- BITMAP_UNION
- BITMAP_XOR
- BITMAP_NOT
- BITMAP_AND_NOT,BITMAP_ANDNOT
- BITMAP_SUBSET_LIMIT
- BITMAP_SUBSET_IN_RANGE
- SUB_BITMAP
- BITMAP_COUNT
- BITMAP_AND_COUNT
- BITMAP_AND_NOT_COUNT,BITMAP_ANDNOT_COUNT
- ORTHOGONAL_BITMAP_UNION_COUNT
- BITMAP_XOR_COUNT
- BITMAP_OR_COUNT
- BITMAP_CONTAINS
- BITMAP_HAS_ALL
- BITMAP_HAS_ANY
- BITMAP_MAX
- BITMAP_MIN
- INTERSECT_COUNT
- BITMAP_INTERSECT
- ORTHOGONAL_BITMAP_INTERSECT
- ORTHOGONAL_BITMAP_INTERSECT_COUNT
- ORTHOGONAL_BITMAP_EXPR_CALCULATE
- ORTHOGONAL_BITMAP_EXPR_CALCULATE_COUNT
- BITMAP_HASH64
- BITMAP_FROM_BASE64
- BITMAP_TO_BASE64
- BITMAP_REMOVE
- Bitwise 函数
- 条件函数
- JSON 函数
- Hash 函数
- HLL 函数
- 数学函数
- 加密和信息摘要函数
- 表函数
- 分析（窗口）函数
- 窗口函数
- WINDOW_FUNCTION_SUM
- WINDOW_FUNCTION_AVG
- WINDOW_FUNCTION_MAX
- WINDOW_FUNCTION_MIN
- WINDOW_FUNCTION_COUNT
- WINDOW_FUNCTION_RANK
- WINDOW_FUNCTION_DENSE_RANK
- WINDOW_FUNCTION_PERCENT_RANK
- WINDOW_FUNCTION_CUME_DIST
- WINDOW_FUNCTION_FIRST_VALUE
- WINDOW_FUNCTION_LAST_VALUE
- WINDOW_FUNCTION_LEAD
- WINDOW_FUNCTION_LAG
- WINDOW_FUNCTION_ROW_NUMBER
- WINDOW_FUNCTION_NTILE
- WINDOW_FUNCTION_WINDOW_FUNNEL
- IP Functions
- IPV4_NUM_TO_STRING
- INET_NTOA
- IPV4_STRING_TO_NUM
- INET_ATON
- IPV4_STRING_TO_NUM_OR_DEFAULT
- IPV4_STRING_TO_NUM_OR_NULL
- IPV6_NUM_TO_STRING
- INET6_NTOA
- IPV6_STRING_TO_NUM
- INET6_ATON
- IPV6_STRING_TO_NUM_OR_DEFAULT
- IPV6_STRING_TO_NUM_OR_NULL
- IS_IPV4_COMPAT
- IS_IPV4_MAPPED
- IPV4_CIDR_TO_RANGE
- IPV6_CIDR_TO_RANGE
- IS_IP_ADDRESS_IN_RANGE
- IS_IPV4_STRING
- IS_IPV6_STRING
- TO_IPV4
- TO_IPV4_OR_DEFAULT
- TO_IPV4_OR_NULL
- TO_IPV6
- TO_IPV6_OR_DEFAULT
- TO_IPV6_OR_NULL
- Vector Distance Functions
- CAST
- DIGITAL_MASKING
- WIDTH_BUCKET
- 数组函数
- SQL 手册
- 集群管理
- 账户管理
- 数据库管理
- SHOW-CONFIG
- ADMIN-SET-CONFIG
- SET-VARIABLE
- INSTALL-PLUGIN
- UNINSTALL-PLUGIN
- ADMIN-SET-REPLICA-STATUS
- ADMIN-SET-REPLICA-VERSION
- ADMIN-SET-PARTITION-VERSION
- ADMIN-SET-TABLE-STATUS
- SHOW-REPLICA-DISTRIBUTION
- SHOW-REPLICA-STATUS
- ADMIN-REPAIR-TABLE
- ADMIN-CANCEL-REPAIR
- ADMIN-CHECK-TABLET
- SHOW TABLET DIAGNOSIS
- ADMIN-COPY-TABLET
- SHOW TABLET STORAGE FORMAT
- ADMIN-CLEAN-TRASH
- RECOVER
- KILL
- ADMIN-REBALANCE-DISK
- ADMIN-CANCEL-REBALANCE-DISK
- UNSET-VARIABLE
- 数据类型
- DDL
- DML
- Show
- SHOW ALTER TABLE MATERIALIZED VIEW
- SHOW-ALTER
- SHOW-ANALYZE
- SHOW-BACKUP
- SHOW-BACKENDS
- SHOW-BROKER
- SHOW-CATALOGS
- SHOW-CREATE-TABLE
- SHOW-CHARSET
- SHOW-CREATE-CATALOG
- SHOW-CREATE-DATABASE
- SHOW-CREATE-MATERIALIZED-VIEW
- SHOW-CREATE-LOAD
- SHOW-CREATE-REPOSITORY
- SHOW-CREATE-ROUTINE-LOAD
- SHOW-CREATE-FUNCTION
- SHOW-COLUMNS
- SHOW-COLUMN-STATS
- SHOW-COLLATION
- SHOW-CONVERT-LIGHT-SCHEMA-CHANGE-PROCESS
- SHOW-DATABASES
- SHOW-DATA-SKEW
- SHOW-DATABASE-ID
- SHOW-DYNAMIC-PARTITION
- SHOW-DELETE
- SHOW-DATA
- SHOW-DATA-TYPES
- SHOW-ENGINES
- SHOW-EVENTS
- SHOW-EXPORT
- SHOW-ENCRYPT-KEY
- SHOW-FUNCTIONS
- SHOW-TYPECAST
- SHOW-FILE
- SHOW-GRANTS
- SHOW-LAST-INSERT
- SHOW-LOAD-PROFILE
- SHOW-LOAD-WARNINGS
- SHOW-INDEX
- SHOW-MIGRATIONS
- SHOW-PARTITION-ID
- SHOW-SNAPSHOT
- SHOW-SQL-BLOCK-RULE
- SHOW-ROUTINE-LOAD
- SHOW-SYNC-JOB
- SHOW-WHITE-LIST
- SHOW-WARNING
- SHOW-TABLET
- SHOW-TABLETS-BELONG
- SHOW-VARIABLES
- SHOW-PLUGINS
- SHOW-ROLES
- SHOW-PROCEDURE
- SHOW-ROUTINE-LOAD-TASK
- SHOW-PROC
- SHOW-TABLE-STATS
- SHOW-TABLE-STATUS
- SHOW-REPOSITORIES
- SHOW-QUERY-PROFILE
- SHOW-OPEN-TABLES
- SHOW-TABLETS
- SHOW-LOAD
- SHOW-TABLES
- SHOW-RESOURCES
- SHOW-WORKLOAD-GROUPS
- SHOW-PARTITIONS
- SHOW-FRONTENDS
- SHOW-FRONTENDS-DISKS
- SHOW-RESTORE
- SHOW-PROPERTY
- SHOW-TRIGGERS
- SHOW-PROCESSLIST
- SHOW-TRASH
- SHOW-VIEW
- SHOW-TRANSACTION
- SHOW-STREAM-LOAD
- SHOW-STATUS
- SHOW-TABLE-ID
- SHOW-SMALL-FILES
- SHOW-POLICY
- SHOW-CATALOG-RECYCLE-BIN
- SHOW-QUERY-STATS
- Operators
- 辅助命令
- SQL 函数
- 管理手册
- 集群管理
- 数据管理
- SQL拦截
- 查询分析
- SSL密钥证书配置
- FE SSL密钥证书配置
- 运维监控
- 内存管理
- 配置管理
- 用户权限及认证
- System Table
- WORKLOAD GROUP
- 多租户和资源划分
- HTTP API
- FE
- Config Action
- HA Action
- Hardware Info Action
- Help Action
- Log Action
- Login Action
- Logout Action
- Query Profile Action
- Session Action
- System Action
- Colocate Meta Action
- Meta Action
- Cluster Action
- Node Action
- Query Profile Action
- Backends Action
- Bootstrap Action
- Cancel Load Action
- Check Decommission Action
- Check Storage Type Action
- Connection Action
- Extra Basepath Action
- Fe Version Info Action
- Get DDL Statement Action
- Get Load Info Action
- Get Load State
- Get FE log file
- Get Small File Action
- Health Action
- Meta Info Action
- Meta Replay State Action
- Metrics Action
- Profile Action
- Query Detail Action
- Query Schema Action
- Query Stats Action
- Row Count Action
- Set Config Action
- Show Data Action
- Show Meta Info Action
- Show Proc Action
- Show Runtime Info Action
- Show Table Data Action
- Statement Execution Action
- Table Query Plan Action
- Table Row Count Action
- Table Schema Action
- Upload Action
- Import Action
- Meta Info Action
- 代码打桩
- Statistic Action
- BE
- FE
- 常见问题
- 性能测试
- 版本发布
暂无相关搜索结果！
本文档使用 WanXiangYunDang 构建
