How to write the mysql summation statement

This article will explain in detail how to write the mysql sum sentence for you. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The mysql sum statement is "select sum (money) from record t where t.name =?", where the parameter t represents an alias for a table.

This article operating environment: Windows7 system, Mysql5.7.14 version, Dell G3 computer.

Example: query name=? in record table The total value of the money of

Summation using the aggregate function sum ()

Select sum (money) from record t where t.name =?

Note: t is an alias for a table. For example, t.name takes the name in the record table, or you can use record.name, but it's just too long, so it's convenient to have an alias.

Extended data:

The aggregate functions are AVG, COUNT, MAX, MIN, and SUM. The syntax of the aggregate function is described in the following example

Aggregation-function ([ALL | DISTINCT] expression)

Or: COUNT ([ALL | DISTINCT] identification-variable)

Or: COUNT (*)

The DISTINCT option eliminates duplicate values before applying the function.

This is the end of this article on "how to write mysql summation sentences". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.