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.

In this tutorial, you will learn how to find the maximum value in a group using the SQL MAX aggregate function.

Nov 22, 2025 · The SQL MAX () function helps quickly identify the highest value within any column, making it useful for summarizing and analyzing data trends. It is widely used in …

Nov 18, 2025 · MAX can be used with numeric, char, nchar, varchar, nvarchar, uniqueidentifier, or datetime columns, but not with bit columns. Aggregate functions and subqueries aren't permitted.

May 5, 2022 · We have learned how to use the SQL MAX function in a basic scenario. Let’s use it along with other SQL clauses in the next use cases of the below sections. This section will …

Sep 4, 2025 · While MAX() function supports the DISTINCT clause, this is only for ISO compatibility. The DISTINCT clause is kind of irrelevant with this function, given there’s still …

The SQL MAX function is used to find the maximum value in a column. It works with numeric, date, and text data types, returning the largest value in the specified column.

Here, the SQL command selects the minimum value of first_name based on the dictionary order. As we know, the MAX() function returns the maximum value. Similarly, the MIN() function …

Following is the syntax of SQL MAX () function −. In the following example, we are running a query for MAX () function on a table named CUSTOMERS. The objective is to retrieve the …

The MAX() function in SQL returns the maximum value from a given column. It’s mostly used with numerical values, dates, and even text columns (where it finds the highest value based on …