{"id":984,"date":"2024-12-15T18:04:27","date_gmt":"2024-12-15T11:04:27","guid":{"rendered":"https:\/\/www.pgtutorial.com\/?page_id=984"},"modified":"2025-01-05T19:44:53","modified_gmt":"2025-01-05T12:44:53","slug":"postgresql-avg","status":"publish","type":"page","link":"https:\/\/www.pgtutorial.com\/postgresql-aggregate-functions\/postgresql-avg\/","title":{"rendered":"PostgreSQL AVG Aggregate Function"},"content":{"rendered":"\n

Summary<\/strong>: In this tutorial, you’ll learn how to use the PostgreSQL AVG<\/code> aggregate function to calculate the average value of a set.<\/p>\n\n\n\n

Getting Started with the PostgreSQL AVG aggregate function #<\/a><\/h2>\n\n\n\n

In PostgreSQL, the AVG<\/code> aggregate function takes a set of numbers and returns their average.<\/p>\n\n\n\n

Here’s the syntax for using the AVG<\/code> aggregate function with a table column:<\/p>\n\n\n

SELECT<\/span>\n  AVG(column1)\nFROM<\/span>\n  table_name<\/span>;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax, the AVG<\/code> function takes all values from column1<\/code> and returns the average.<\/p>\n\n\n\n
\n
Note:<\/strong> The AVG<\/code> function ignores NULL<\/a><\/code> from its calculation. Additionally, if column1<\/code> has no value, the AVG<\/code> function returns NULL<\/code>.<\/p>\n<\/blockquote>\n\n\n\n
Finding averages for groups #<\/a><\/h3>\n\n\n\n
To find averages for groups, you can use the AVG<\/code> function with the GROUP BY<\/a><\/code> clause:<\/p>\n\n\n
SELECT<\/span>\n  column2,\n  AVG(column1)\nFROM<\/span>\n  table_name<\/span>\nGROUP<\/span> BY<\/span>\n  column2;<\/code><\/span>Code language:<\/span> PostgreSQL SQL dialect and PL\/pgSQL<\/span> (<\/span>pgsql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n