SQL MIN

SQL MIN

The SQL MIN function returns the minimum value in a select query.

MIN syntax

SELECT MIN(table_column)
FROM table_name;

MIN example

Coder books table

SELECT MIN(price) 
FROM coder_books;

Result

17

SELECT price, MIN(price) min_price
FROM coder_books
GROUP BY price
HAVING count(*) > 1;

Result