Filtering Rows Using Aggregate Functions

Examples of Filtering Rows Using Aggregate Functions in PostgreSQL

The ability of the aggregate functions to work can be seen better when they are applied together with the HAVING clause to filter rows based on aggregated values. The HAVING condition works in the same way as the WHERE condition but is designed specifically to filter collections of rows returned by aggregate queries.

Now we do some practical examples to display the process of adding aggregate functions and filtering rows.

Let’s start by creating a simple table, putting some sample data in, and then showing a few filters of rows using aggregate functions in PostgreSQL.

Create Table

CREATE TABLE sales (
    salesperson VARCHAR(50),
    sales_amount NUMERIC
);

Insert Data

INSERT INTO sales (salesperson, sales_amount) VALUES
('Minal', 5000),
('Priyanshi', 8000),
('Mridul', 7000),
('Asad', 12000),
('Maram', 6000),
('Mahi', 10000);

Output:

Now, we have a table named “sales” with some sample data.

Sales Table