SQL MIN() Function

The MIN() Function

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

SQL MIN() Syntax

SELECT MIN(column_name) FROM table_name;

SQL MIN() Example

The following SQL statement gets the smallest value of the “Price” column from the “Products” table:

Example

SELECT MIN(Price) AS SmallestOrderPrice FROM Products;

No comments yet.

Leave a Reply

*