HOME | PHP Tutorial | CSS
facebook icon
AgerNic.com
WEB DEVELOPER SITE, HTML, CSS, PHP
HTML Tutorial

CSS Tutorial

SQL COUNT(), AVG() and SUM() Functions


The COUNT() function returns the number of rows that matches a specified criteria.
The AVG() function returns the average value of a numeric column.
The SUM() function returns the total sum of a numeric column.

SQL COUNT(), AVG() and SUM() Functions - how to create - example


COUNT() Syntax

Example 1: COUNT() Syntax
SELECT COUNT(column_name)
FROM table_name
WHERE condition;


AVG() Syntax

Example 2: AVG() Syntax
SELECT AVG(column_name)
FROM table_name
WHERE condition;


SUM() Syntax

Example 3: SUM() Syntax
SELECT SUM(column_name)
FROM table_name
WHERE condition;

sql count avg and sum functions SQL COUNT(), AVG() and SUM() Functions - sql tutorial

3228. SQL - Syntax, sql tutorial
SQL - Syntax sql tutorial
https://www.agernic.com/sql-tutorial/sql-syntax.html

2561. ETL - Extract, Transform and Load - SQL Tutorial

http://www.sql-tutorial.net/ETL.asp

3289. SQL create table primary key autoincrement, sql tutorial
SQL create table primary key autoincrement sql tutorial
https://www.agernic.com/sql-tutorial/sql-create-table-primary-key-autoincrement.html

2563. SQL Aliases - SQL Tutorial

http://www.sql-tutorial.net/SQL-Aliases.asp

3285. PHP mysqli_connect () Function, sql tutorial
PHP mysqli_connect () Function sql tutorial
https://www.agernic.com/sql-tutorial/php-mysqli-connect-function.html

2589. SQL WHERE - SQL Tutorial

http://www.sql-tutorial.net/SQL-WHERE.asp

Your add here
How to get PHP errors to display?
How to prevent sql injection in php mysqli
How do I get PHP errors to display - PHP error_reporting()
mysql_query(): The mysql extension is deprecated and will be removed i
Function eregi_replace() is deprecated in php - How to fix
PHP delete an element from an array
Uncaught Error: Call to undefined function MYSQL_NUM_ROWS() in
Deprecated: mysql_connect() mysql extension is deprecated and will be
mysqli_fetch_array() expects parameter 1 to be mysqli_result boolean g
SQL IN Operator - example
SQL BETWEEN Operator
SQL like syntax and example
SQL WHERE AND & OR multiple conditions
SQL create table primary key autoincrement
PHP mysqli_connect () Function
SQL COUNT(), AVG() and SUM() Functions
Display data from SQL database with MySQLi into php - html table
SQL CREATE DATABASE - example
SQL mysql order by columns, by date, by asc, by desc, random with PHP
PHP mysqli_query() Function - mysqli query
SQL delete row - SQL delete table
SQL update - SQL update select
Insert into SQL - Insert into table SQL - Insert data in sql
Login in PHP - simple login script with PHP MYSQL