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
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 8.0 Reference Manual
Preface and Legal Notices
General Information
Installing and Upgrading MySQL
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
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 Utility Functions
JSON Path Syntax
Functions Used with Global Transaction IDs
Aggregate (GROUP BY) Functions
Aggregate (GROUP BY) Function Descriptions
GROUP BY Modifiers
MySQL Handling of GROUP BY
Detection of Functional Dependence
Window Functions
Window Function Descriptions
Window Function Concepts and Syntax
Window Function Frame Specification
Named Windows
Window Function Restrictions
Internal Functions
Miscellaneous Functions
Precision Math
Types of Numeric Values
DECIMAL Data Type Characteristics
Expression Handling
Rounding Behavior
Precision Math Examples
SQL Statement Syntax
MySQL Data Dictionary
The InnoDB Storage Engine
Alternative Storage Engines
High Availability and Scalability
Replication
MySQL Shell User Guide
Using MySQL as a Document Store
Group Replication
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 8.0 Frequently Asked Questions
Errors, Error Codes, and Common Problems
Restrictions and Limits
Indexes
MySQL Glossary
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 32.9Mb
PDF (A4)
- 32.9Mb
PDF (RPM)
- 30.8Mb
HTML Download (TGZ)
- 7.8Mb
HTML Download (Zip)
- 7.9Mb
HTML Download (RPM)
- 6.7Mb
Man Pages (TGZ)
- 145.0Kb
Man Pages (Zip)
- 205.3Kb
Info (Gzip)
- 3.0Mb
Info (Zip)
- 3.0Mb
version 8.0
5.7 current
5.6
5.5
5.6 Japanese
MySQL 8.0 Reference Manual
/
Functions and Operators
/ Aggregate (GROUP BY) Functions
Pre-General Availability Draft: 2017-07-17
12.18Â Aggregate (GROUP BY) Functions
[
+/-
]
12.18.1 Aggregate (GROUP BY) Function Descriptions
12.18.2 GROUP BY Modifiers
12.18.3 MySQL Handling of GROUP BY
12.18.4 Detection of Functional Dependence
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.0 Release Notes
MySQL 8.0 Source Code Documentation
Download this Manual
PDF (US Ltr)
- 32.9Mb
PDF (A4)
- 32.9Mb
PDF (RPM)
- 30.8Mb
HTML Download (TGZ)
- 7.8Mb
HTML Download (Zip)
- 7.9Mb
HTML Download (RPM)
- 6.7Mb
Man Pages (TGZ)
- 145.0Kb
Man Pages (Zip)
- 205.3Kb
Info (Gzip)
- 3.0Mb
Info (Zip)
- 3.0Mb
User Comments
Sign Up
Login
You must be logged in to post a comment.