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 andlt; 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.

Revati S Misra

Can you answer this question?

1 Answers

Liked By