MySQL SQL

MySQL MIN()

Find the smallest non-null value.

SELECT MIN(price) AS lowest_price
FROM products;

MIN() can be combined with GROUP BY to find the minimum value for each category.