Explain the purpose of the MAX() and MIN() functions in SQL and provide examples.

Question

Aryan Kumar · Answer

Sure. The MAX() and MIN() functions in SQL are aggregate functions that are used to return the maximum and minimum values of a column, respectively. The syntax for the MAX() and MIN() functions is:

SQL

MAX(column_name)
MIN(column_name)

column_name is the name of the column that you want to return the maximum or minimum value of.

The MAX() and MIN() functions can be used in a variety of ways, such as:

To find the maximum or minimum value of a column in a table.
To filter results based on the maximum or minimum value of a column.
To compare the maximum or minimum value of a column to other values.

For example, the following query will return the maximum price of all products in the products table:

SQL

SELECT MAX(price)
FROM products;

The following query will return all products in the products table where the price is less than the maximum price:

SQL

SELECT *
FROM products
WHERE price < MAX(price);

The following query will return the minimum age of all customers in the customers table:

SQL

SELECT MIN(age)
FROM customers;

The following query will return all customers in the customers table where the age is greater than the minimum age:

SQL

SELECT *
FROM customers
WHERE age > MIN(age);

The MAX() and MIN() functions are powerful tools that can be used to perform a variety of tasks with your SQL data.

forum

Explain the purpose of the MAX() and MIN() functions in SQL and provide examples.

Can you answer this question?

1 Answers