WRITE FOR US

SQL MAX Function - SQL Server MAX() Function

The SQL MAX() Function

The MAX() function retrieves the highest value from a specified column, offering a straightforward way to find the maximum value.

Demo Database

Here is a selection from the Products table used in the examples:

table -Wikitechy

Syntax

SELECT MAX(column_name) FROM table_name;

The MAX() function retrieves the highest value from a chosen column, providing a straightforward way to find the maximum value.

Example

SELECT MAX(Mark) FROM tbl_Wikitechy;

Output

sql-max-function

Related Searches to SQL MAX Function - SQL Server MAX() Function

sql min() and max() functions sql server max() function sql max() and min() with examples sql max function sql min() and max() sql max tutorial sql max between two values sql min and max in same query sql max function sql max function example sql select max value and other columns