Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL中的聚合函数_MySQL

MySQL中的聚合函数_MySQL

WBOY
Release： 2016-06-01 13:18:39
Original
1462 people have browsed it

bitsCN.com

1、count（）返回某列的行数

2、avg（）返回某列的平均值

3、max（）返回某列的最大值

4、min（）返回某列的最小值

5、sum（）返回某列的和

6、distinct 去除重复值

avg（）忽略值为null的行

count（*）时统计所有行，count（列）时忽略为null的行

bitsCN.com
Related labels：
count
source：php.cn
Previous article：MySQL存储引擎 InnoDB与MyISAM的区别_MySQL Next article：(转)Amoeba for MySQL 非常好用的mysql集群软件_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
From 2024-04-06 21:44:19
0
1
603
SQL Count() also requires 0 I have only one table and I want to count each entry of a tag that starts with 0. Now I tr...
From 2024-04-06 19:48:53
0
1
449
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
MySQL operation to get maximum sum function I'm trying to set the maximum quantity to "max" and I'm getting the error: Error...
From 2024-04-04 17:49:26
0
1
376
Proper use of the COUNT function in MySQL I have 2 tables, this is my fiddle http://sqlfiddle.com/#!9/da5e4e/3 so basically I have 2...
From 2024-04-04 13:50:47
0
1
293
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template