Mega Code Archive
Search
.Net
ASP .Net
ASP .Net Tutorial
C#
C# Book
C# by API
C# Tutorial
VB.Net
VB.Net by API
VB.Net Tutorial
Visual C++ .Net
VisualBasic Script
Java
Java
Java Book
Java by API
Java Tutorial
Script
Flash ActionScript
Flex
JavaScript DHTML
JavaScript Reference
JavaScript Tutorial
Database
MSSQL
MSSQL Tutorial
MySQL
MySQL Tutorial
Oracle PLSQL
Oracle PLSQL Tutorial
PostgreSQL
Languages
Android
C
C Tutorial
C++
C++ Tutorial
Delphi
Perl
PHP
Python
Python Tutorial
Ruby
Silverlight
Office
MSOfficeExcel 2007 Tutorial
MSOfficePowerPoint 2007 Tutorial
MSOfficeWord 2007 Tutorial
Data
XML
XML Tutorial
MySQL Tutorial
Aggregate Functions 38 codes
Home
MySQL Tutorial
Aggregate Functions
1 A SUM() function can be added to CASE statement to give us the total
2 Aggregate Functions
3 AVG with NULL value
4 AVG() can work out more that one value at a time when used with a GROUP BY clause
5 AVG() can work with a join
6 AVG() can work with other functions
7 AVG([DISTINCT] expr)
8 Count()
9 COUNT(column name)
10 COUNT(DISTINCT expr,[expr ]) (Returns a count of the number of different non-NULL values )
11 Distinct count
12 Get the average of a set of sums for a grouped table
13 GROUP_CONCAT(expr) returns a string result with the concatenated non-NULL values from a group
14 MAX function with date value
15 MAX function with number value
16 MAX function with text value
17 Maximum of Column per Group
18 MIN function and number value
19 MIN function with date value
20 MIN function with text value
21 Return the total number of rows
22 STD function with NULL value
23 STD(expr)STDDEV(expr) returns the population standard deviation of expr
24 STDDEV_POP(expr) returns the population standard deviation of expr (the square root of VAR_POP())
25 STDDEV_SAMP(expr) returns the sample standard deviation of expr (the square root of VAR_SAMP()
26 SUM function with column calculation
27 SUM with NULL value
28 SUM() function totals the values in a given column
29 The STD() function returns the standard deviation of a given column
30 The SUM() and AVG() aggregate functions do not work with temporal values
31 Use aggregate function with group by clause
32 Use and IF() and COUNT() to give us a total as COUNT() ignores NULL values
33 Use two aggregate functions in a select statement
34 Using COUNT() in a table JOIN
35 Using SUM([DISTINCT] expr) function to sum the salary
36 VAR_POP(expr) returns the population standard variance of expr
37 VAR_SAMP(expr) returns the sample variance of expr
38 VARIANCE(expr) returns the population standard variance of expr