In today’s article, we will explain and give an example about the MIN() Function, which returns the minimum value in PostgreSQL.
PostgreSQL MIN() function is an aggregate function that returns the minimum value in a set of values.
For example, if we want to see the object sold at the lowest price among the products in our warehouse table, the script below will help us.
First, let’s take a look at the data in our table.
We can use the command below to see the lowest sales price in the table.
select min(sales_price) from depo;