The SQL MAX () Function The MAX () function returns the largest value of the selected column. The MAX () function works with numeric, string, and date data types.

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 reports to find top …

Jul 20, 2026 · 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.

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

May 5, 2022 · Learn about the SQL MAX () function in SQL Server to find the maximum values in a result set along with several examples of using SQL MAX ().

Here we use the MIN () function and the GROUP BY clause, to return the smallest price for each category in the Products table: You will learn more about the GROUP BY clause later in this tutorial.

This tutorial shows you how to use the SQL Server MAX () function to find the maximum value in a set of values.

Aug 13, 2025 · The SQL MIN () and MAX () functions are essential aggregate functions used to find the smallest and largest values in a column. They work with various data types such as numbers, …

In this tutorial, you will learn about the MAX () and MIN () functions in SQL with the help of examples.

Aug 31, 2021 · This article explains the aggregate functions MIN and MAX, how to use them, and when to use the MIN/MAX with window functions. Includes practical examples!