SQL SERVER MAX: Display the Maximum Number in Column

SQL Max is used to find the maximum value in a certain column in a table. In my example, I have the SALES table below with records.

Syntax

select MAX(column_name) from table_name

Table

To display 60.00 which is the maximum amount found in the total column, you need the following SQL Max function.

Syntax

select MAX(total) from sales

SQL SERVER MAX: Display the Maximum Number in Column

SQL SERVER MAX: Display the Maximum Number in Column 2016-01-29T05:41:00-08:00 Rating: 4.5 Diposkan Oleh: Emoblazz