SQL AVG () function

SqlAVG () function AVG () function

The AVG () function returns the average of a numeric column.

SQL AVG () syntax

SELECT AVG  from table_name

Demo Database

In this tutorial, we will use the Runoob sample database.

The following is the data selected from the "Access_log" table:

+-----+---------+-------+------------+|Aid|site_id| Count |Date|+-----+---------+-------+------------+|   1 |       1 |     $ |  .- to-Ten ||   2 |       3 |    - |  .- to- - ||   3 |       1 |    the |  .- to- - ||   4 |       2 |    Ten |  .- to- - ||   5 |       5 |   205 |  .- to- - ||   6 |       4 |     - |  .- to- the ||   7 |       3 |    - |  .- to- the ||   8 |       5 |   545 |  .- to- - ||   9 |       3 |   201 |  .- to- - |+-----+---------+-------+------------+

SQL AVG () instance

The following SQL statement gets the average value from the "Count" column of the "Access_log" table:

Instance

SELECT AVG (count as from Access_log;

Execute the above SQL output as follows:

The following SQL statement selects "site_id" and "count" for access above the average number of accesses:

Instance

SELECT Count  from Access_log WHERE Count > (SELECTAVG(count from Access_log);

Execute the above SQL output as follows:

SQL AVG () function