PostgreSQL MIN and MAX Functions

MIN

The MIN() function returns the smallest value of the selected column.

Example

Return the lowest price in the products table:

SELECT MIN(price)
FROM products;

---

MAX

The MAX() function returns the largest value of the selected column.

Example

Return the highest price in the products table:

SELECT MAX(price)
FROM products;

---

Set Column Name

When you use MIN() or MAX(), the returned column will be named min or max by default. To give the column a new name, use the AS keyword.

Example

Return the lowest price, and name the column lowest_price:

SELECT MIN(price) AS lowest_price
FROM products;

---

PostgreSQL Exercises

Test Yourself With Exercises

Exercise:

Use the correct function to return the lowest value from the field price in the table products.SELECT FROM products;