How to use max in sql

Editor to share with you the use of max in sql, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

MAX () function

The MAX function returns the maximum value in a column. The NULL value is not included in the calculation.

SQL MAX () syntax

SELECT MAX (column_name) FROM table_name

Note: MIN and MAX can also be used for text columns to get the highest or lowest values in alphabetical order.

SQL MAX () instance

We have the following "Orders" table:

Now, we want to find the maximum value of the "OrderPrice" column.

We use the following SQL statement:

SELECT MAX (OrderPrice) AS LargestOrderPrice FROM Orders

The result set looks like this:

The above is all the contents of the article "how to use max in sql". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!