Blog

MAX SQL FUNCTION

In this tutorial I will explain how to calculate max and min in sql.

To perform the queries I will use the SQL SELECT query in several examples.

Also, I’m going to show you examples on MAX and SELECT from simpler to advanced so that you can find the solution to your problem.

Content

  • How to calculate max in SQL?
    • Know the SQL SELECT query
    • Using the SQL MAX() function
  • Examples of MAX SQL with SELECT
    • SQL MAX function example 1
    • Example of MAX and GROUP BY
    • Advanced example of MAX and HAVING
  • SELECT MAXSQL? What else?

How to calculate max in SQL?

To be able to calculate the maximum in SQL you will need to have a couple of clear knowledge:

  1. How the SELECT SQL query is used
  2. Know how to use SQL functions and specifically the MAX() function

Know the SQL SELECT query

As a quick review, the structure of a SELECT is:

SELECT columna1, columna2, ...
FROM tabla
[WHERE condiciones]

Using the SQL MAX() function

The SQL MAX function It is used in the same way as all SQL functions: by calling it by its name together with the parentheses.

The MAX function syntax is:

MAX( columna )

The function MAX calculates the maximum between the values ​​in the column specified. Technically we say that it returns an “aggregate record” since it returns a result row of the calculation among all rows provided.

Knowing this let’s see the examples.

Examples of MAX SQL with SELECT

Now let’s get down to business, let’s see several examples of queries with MAX.

SQL MAX function example 1

The following function would return a row with a column “max_age” with the maximum value among all the rows in the “user” table.

SELECT MAX(edad) as edad_maxima
FROM usuario;

Example of MAX and GROUP BY

Now imagine that we want to know what is the maximum age of the students of each course of a university.

We could make use of the following query:

SELECT MAX(edad) as edad_maxima, curso
FROM alumnos
GROUP BY curso;

Advanced example of MAX and HAVING

Finally I am going to leave you a more advanced query, making use of the max SQL function and the SQL HAVING clause. Specifically, I am going to select those courses that have at least one student who is over the age of 30:

SELECT c.*
FROM alumno a INNER JOIN curso c ON a.id_curso = c.id
GROUP BY c.id
HAVING MAX(a.edad) > 30;

SELECT MAXSQL? What else?

Well I hope this helped you post about SQL MAX function. If so, it would help us a lot if you shared this content or left a comment that helps other users and motivates us to continue publishing.

Thank you!

Leave a Reply