PostgreSQL – MIN() Function
Last Updated :
01 Jun, 2020
PostgreSQL MIN() function is an aggregate function that returns the minimum value in a set of values.
Syntax: MIN(expression);
The MIN() function can be used with SELECT, WHERE and HAVING clause.
Now let’s look into some examples.For examples we will be using the sample database (ie, dvdrental).
Example 1:
The below query gets us the minimum amount paid by customers in the payment
table:
SELECT MIN(amount)
FROM payment;
Output:
Example 2:
The following query gets the smallest payment paid by each customer:
SELECT
customer_id,
MIN(amount)
FROM
payment
GROUP BY
customer_id;
Output:
Share your thoughts in the comments
Please Login to comment...