Tag: sql max function performance

SQL MAX Function

Example

Find the price of the most expensive product in the “Products” table:

SELECT MAX(Price) AS LargestPrice FROM Products;

Definition and Usage

The MAX() function returns the maximum value in a set of values.

Note: Also look at the MIN() function.

Syntax

MAX(expression)

Continue reading SQL MAX Function

SQL MIN() and MAX() Functions

The SQL MIN() and MAX() Functions

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

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

MIN Example

Find the lowest price in the Price column:

SELECT MIN(Price)
FROM Products;

Continue reading SQL MIN() and MAX() Functions