Learn SQL: MAX and MIN aggregate functions

Today, we will take it further and tell you about MIN and MAX aggregate functions. As you can easily guess from their names, they are designed to find the smallest and largest values in the selected column of the table.

If you apply the MAX or MIN function to a column of numeric type, you will get the largest or smallest number in that column as a result, respectively. It is worth noting that these functions can also be used on columns containing strings. However, this topic is full of nuances and deserves a separate discussion, and today we will talk about the use of MAX and MIN functions for numeric values, which is a common practice.

--
--
--
Contact us:

--
Subscribe to our channel to get more interesting videos about DBeaver and the database world!