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...