Aggregate Functions in Postgres on ObjectRocket

Introduction When you’re querying your PostgreSQL database, using aggregate functions can help you group your result set in more meaningful ways. With the help of functions like SUM(), COUNT() and AVG(), you can gain better insights into your data. In this article, we’ll take a closer look at these functions and show you how to … Continued

Postgres Aggregate Functions

Introduction In this lesson we learn how to use the following Postgres aggregate functions: AVG function and SUM function, which are both aggregate functions in PostgreSQL. We also explore a statement required for filtering of aggregated data; “HAVING”. Prerequisites An understanding of how SQL queries fit into the Postgres database system and the means to … Continued

Keep in the know!

Subscribe to our emails and we’ll let you know what’s going on at ObjectRocket. We hate spam and make it easy to unsubscribe.