Tuesday, April 26, 2016

AVG Function (SQL)

Over the last couple of coding posts I have showed you how to use the SUM function.  This being said, I thought I would show you how to use the AVE function in SQL.  

Use the AVG() Function to get the average of a of a specific numeric column.  Below is an example of it being used.

SQL AVG Example:

SELECT  AVG(ColumnName) 
FROM TableName;

If you like this post and want to see more, follow me on my website www.chadcompton.com
Or if you prefer...