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

2578. SQL LIKE - SQL Tutorial

http://www.sql-tutorial.net/SQL-LIKE.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

3290. SQL delete row - SQL delete table, sql tutorial
SQL delete row - SQL delete table sql tutorial
https://www.agernic.com/sql-tutorial/sql-delete-row-sql-delete-table.html

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

2567. SQL Cheat Sheet - SQL Tutorial

http://www.sql-tutorial.net/SQL-Cheat-Sheet.asp

2819. SQL Tutorial
Gives you clear, concise and easy to understand SQL tutorial with practical examples. You will learn how to write SQL query like a Pro.
http://www.zentut.com/sql-tutorial/

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