Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
          • Load Data
            • Query Data
              • Manage Data
                • Developer Resources
                  • User and Cluster Administration
                    • Reference
                      • Configuration Reference
                        • SingleStoreDB Operator Reference
                          • SingleStore Tools Reference
                            • SQL Reference
                              • SQL Command Syntax
                              • SQL Commands List
                              • SQL Functions List
                              • Comparison Operators and Functions
                                • Database Object Case-Sensitivity
                                • Data Types
                                  • Character Encoding
                                    • Operations that Take Either a Database or a Cluster Level Lock
                                      • User-Defined Variables
                                        • Restricted Keywords
                                          • Aggregate Functions
                                            • ANY_VALUE
                                            • APPROX_COUNT_DISTINCT
                                            • APPROX_PERCENTILE
                                            • AVG
                                            • BIT_AND
                                            • BIT_OR
                                            • BIT_XOR
                                            • COUNT
                                            • GROUP_CONCAT
                                            • MAX
                                            • MEDIAN
                                            • MIN
                                            • MOD
                                            • STD
                                            • STDDEV
                                            • STDDEV_POP
                                            • STDDEV_SAMP
                                            • SUM
                                            • VARIANCE
                                            • VAR_SAMP
                                          • Cluster Management Commands
                                            • Code Generation Functions
                                              • Conditional Functions
                                                • Data Definition Language DDL
                                                  • Data Manipulation Language DML
                                                    • Date and Time Functions
                                                      • Distinct Count Estimation Functions
                                                        • Full-Text Search Functions
                                                          • Geospatial Functions
                                                            • Identifier Generation Functions
                                                              • Information Functions
                                                                • JSON Functions
                                                                  • Numeric Functions
                                                                    • Operational Commands
                                                                      • Pipelines Commands
                                                                        • Procedural SQL Reference
                                                                          • Regular Expression Functions
                                                                            • Resource Pool Commands
                                                                              • Security Management Commands
                                                                                • SHOW Commands
                                                                                  • String Functions
                                                                                    • Time Series Functions
                                                                                      • Vector Functions
                                                                                        • Window Functions
                                                                                        • Troubleshooting Reference
                                                                                          • System Databases
                                                                                          • Information Schema Reference
                                                                                            • Data API
                                                                                              • Code Engine - Powered by Wasm
                                                                                              • Security
                                                                                                • Release Notes
                                                                                                  • Support
                                                                                                    • Glossary
                                                                                                    1. Self-Managed v8.0
                                                                                                    2. /
                                                                                                    3. ...
                                                                                                    4. /
                                                                                                    5. Aggregate Functions

                                                                                                    Aggregate Functions

                                                                                                    In this section

                                                                                                    • ANY_VALUE
                                                                                                    • APPROX_COUNT_DISTINCT
                                                                                                    • APPROX_PERCENTILE
                                                                                                    • AVG
                                                                                                    • BIT_AND
                                                                                                    • BIT_OR
                                                                                                    • BIT_XOR
                                                                                                    • COUNT
                                                                                                    • GROUP_CONCAT
                                                                                                    • MAX
                                                                                                    • MEDIAN
                                                                                                    • MIN
                                                                                                    • MOD
                                                                                                    • STD
                                                                                                    • STDDEV
                                                                                                    • STDDEV_POP
                                                                                                    • STDDEV_SAMP
                                                                                                    • SUM
                                                                                                    • VARIANCE
                                                                                                    • VAR_SAMP

                                                                                                    Last modified: November 17, 2022

                                                                                                    Was this article helpful?

                                                                                                    List of Restricted Keywords
                                                                                                    ANY_VALUE

                                                                                                    Product

                                                                                                    • Product Overview
                                                                                                    • Solutions
                                                                                                    • Pricing
                                                                                                    • Support

                                                                                                    Community

                                                                                                    • Forums
                                                                                                    • Developer Hub
                                                                                                    • Events
                                                                                                    • Training

                                                                                                    Company

                                                                                                    • Contact Us
                                                                                                    • Blog
                                                                                                    • Careers
                                                                                                    • SingleStore Connect

                                                                                                    This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                    • © SingleStore
                                                                                                    • |

                                                                                                    • Privacy Policy
                                                                                                    • |

                                                                                                    • Terms of Service
                                                                                                    • |

                                                                                                    • Legal Terms and Conditions

                                                                                                    Was this article helpful?