: SUM : Aggregate Functions MySQL TUTORIALS
Ajax
Ajax Examples
Ajax Tutorials
Scripts and Programs
Javascript
Javascript Examples Tutorials
DHTML Tutorials
Javascript References
Scripts and Programs
HTML
HTML Tutorials
HTML References
HTML DOM 0 References
HTML DOM 2 References
CSS
CSS Tutorials
CSS References
PHP
PHP Source Code
PHP References
Scripts and Programs
C#
C# Source Code
C# Examples
MySQL TUTORIALS
»
Aggregate Functions
»
SUM
»
280.1 .
The SUM() and AVG() aggregate functions do not work with temporal values.
Hits: 1393
280.2 .
Get the average of a set of sums for a grouped table
Hits: 1266
280.3 .
SUM function with column calculation
Hits: 1467
280.4 .
SUM() function totals the values in a given column.
Hits: 1259
280.5 .
SUM with NULL value
Hits: 1516
280.6 .
A SUM() function can be added to CASE statement to give us the total
Hits: 1264
280.7 .
Using SUM([DISTINCT] expr) function to sum the salary
Hits: 1452
MySQL TUTORIALS
Aggregate Functions
»
SUM
Introduction
STDDEV_POP
AVG
STDDEV_SAMP
Count
SUM
GROUP_CONCAT
VARIANCE
MAX
VAR_POP
MIN
VAR_SAMP
STD
Aggregate Functions
Cast Functions Operators
Comparison Functions Operators
Control Flow Functions
Cursor
Data Dictionary
Data Types
Database
Date Time Functions
Encryption Compression Functions
Information Functions
Insert Update Delete
Introduction
Logic Operator
Math Numeric Functions
Miscellaneous Functions
MySQL Utilities
Privilege
Procedure Function
Regular Expressions
Select Query
String Functions
Subquery
Table
Table Join
Trigger
View
The SUM() and AVG() aggregate functions do not work with temporal values.
