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

PHP forms
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

2576. SQL INSERT INTO - SQL Tutorial

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

2574. SQL Hosting - SQL Tutorial

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

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

2584. SQL SELECT - SQL Tutorial

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

3295. SQL mysql order by columns, by date, by asc, by desc, random with PHP, sql tutorial
SQL mysql order by columns, by date, by asc, by desc, random with PHP sql tutorial
https://www.agernic.com/sql-tutorial/sqlL-mysql-order-by-columns-asc--desc--random-with-php.html

Your add here
PHP define() function

PHP str_repeat() function

PHP str_split() function

PHP empty() Function

PHP count() Function

PHP strtoupper() function

PHP strstr() function

PHP lcfirst() function

PHP strip_tags() function

PHP htmlentities() function

PHP rtrim() function

PHP strrchr() Function

PHP substr() function

PHP strtolower() function

PHP wordwrap() function

PHP ltrim() function

CSS link color - CSS link href HTML - Link without underline
Deprecated: mysql_connect() mysql extension is deprecated and will be
HTML table style, HTML border, width and height
SQL like syntax and example
SQL update - SQL update select
SQL tutorial will teach you how to use SQL - Database