Sullivan Market

a web based full-circle development system

My SQL Tutorials - Average

Computing a Column Average (AVG):     The AVG() column function computes the average of a column of data values. The data in the column must have a numeric type, which is the case for the SUM() function. The AVG() function adds the values in the column and then divides this value by the number of values. This result must have a different data type than that of the values in the column. Here is an example of the AVG() column function...  

Select Avg(Internet_Usage_length)
From InternetUsage_Table;

Back To SQL Tutorials