MySQL :: MySQL 5.7 Reference Manual :: 13.19 Aggregate (GROUP BY) Functions

MySQL :: MySQL 5.7 Reference Manual :: 13.19 Aggregate (GROUP BY) Functions Contact MySQL  |  Login  |  Register The world's most popular open source database MySQL.com Downloads Documentation Developer Zone Developer Zone Downloads MySQL.com Documentation MySQL Server MySQL Enterprise Workbench Router Utilities/Fabric MySQL NDB Cluster Connectors More MySQL.com Downloads Developer Zone Section Menu:   Documentation Home MySQL 5.7 Reference Manual Preface and Legal Notices General Information Installing and Upgrading MySQL Using MySQL as a Document Store Tutorial MySQL Programs MySQL Server Administration Security Backup and Recovery Optimization Language Structure Globalization Data Types Functions and Operators Function and Operator Reference Type Conversion in Expression Evaluation Operators Operator Precedence Comparison Functions and Operators Logical Operators Assignment Operators Control Flow Functions String Functions String Comparison Functions Regular Expressions Character Set and Collation of Function Results Numeric Functions and Operators Arithmetic Operators Mathematical Functions Date and Time Functions What Calendar Is Used By MySQL? Full-Text Search Functions Natural Language Full-Text Searches Boolean Full-Text Searches Full-Text Searches with Query Expansion Full-Text Stopwords Full-Text Restrictions Fine-Tuning MySQL Full-Text Search Adding a Collation for Full-Text Indexing ngram Full-Text Parser MeCab Full-Text Parser Plugin Cast Functions and Operators XML Functions Bit Functions and Operators Encryption and Compression Functions Information Functions Spatial Analysis Functions Spatial Function Reference Argument Handling by Spatial Functions Functions That Create Geometry Values from WKT Values Functions That Create Geometry Values from WKB Values MySQL-Specific Functions That Create Geometry Values Geometry Format Conversion Functions Geometry Property Functions General Geometry Property Functions Point Property Functions LineString and MultiLineString Property Functions Polygon and MultiPolygon Property Functions GeometryCollection Property Functions Spatial Operator Functions Functions That Test Spatial Relations Between Geometry Objects Spatial Relation Functions That Use Object Shapes Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs) MySQL-Specific Spatial Relation Functions That Use Minimum Bounding Rectangles (MBRs) Spatial Geohash Functions Spatial GeoJSON Functions Spatial Convenience Functions JSON Functions JSON Function Reference Functions That Create JSON Values Functions That Search JSON Values Functions That Modify JSON Values Functions That Return JSON Value Attributes JSON Path Syntax Functions Used with Global Transaction IDs MySQL Enterprise Encryption Functions Enterprise Encryption Installation Enterprise Encryption Usage and Examples Enterprise Encryption Function Reference Enterprise Encryption Function Descriptions Aggregate (GROUP BY) Functions Aggregate (GROUP BY) Function Descriptions GROUP BY Modifiers MySQL Handling of GROUP BY Detection of Functional Dependence Miscellaneous Functions Precision Math Types of Numeric Values DECIMAL Data Type Characteristics Expression Handling Rounding Behavior Precision Math Examples SQL Statement Syntax The InnoDB Storage Engine Alternative Storage Engines High Availability and Scalability Replication MySQL NDB Cluster 7.5 Partitioning Stored Programs and Views INFORMATION_SCHEMA Tables MySQL Performance Schema MySQL sys Schema Connectors and APIs Extending MySQL MySQL Enterprise Edition MySQL Workbench MySQL 5.7 Frequently Asked Questions Errors, Error Codes, and Common Problems Restrictions and Limits Indexes MySQL Glossary Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB - 8.7Mb HTML Download (TGZ) - 8.5Mb HTML Download (Zip) - 8.5Mb HTML Download (RPM) - 7.3Mb Eclipse Doc Plugin (TGZ) - 9.3Mb Eclipse Doc Plugin (Zip) - 11.5Mb Man Pages (TGZ) - 203.5Kb Man Pages (Zip) - 308.9Kb Info (Gzip) - 3.3Mb Info (Zip) - 3.3Mb Excerpts from this Manual MySQL Backup and Recovery MySQL Globalization MySQL Information Schema MySQL Installation Guide MySQL and Linux/Unix MySQL and OS X MySQL Partitioning MySQL Performance Schema MySQL Replication Using the MySQL Yum Repository MySQL Restrictions and Limitations Security in MySQL MySQL and Solaris Building MySQL from Source Starting and Stopping MySQL MySQL Tutorial MySQL and Windows MySQL Cluster NDB 7.5 version 5.7 8.0 5.6 5.5 5.6  Japanese MySQL 5.7 Reference Manual  /  Functions and Operators  /  Aggregate (GROUP BY) Functions 13.19 Aggregate (GROUP BY) Functions [ +/- ] 13.19.1 Aggregate (GROUP BY) Function Descriptions 13.19.2 GROUP BY Modifiers 13.19.3 MySQL Handling of GROUP BY 13.19.4 Detection of Functional Dependence PREV   HOME   UP   NEXT Related Documentation MySQL 5.7 Release Notes Download this Manual PDF (US Ltr) - 35.7Mb PDF (A4) - 35.7Mb PDF (RPM) - 34.7Mb EPUB -