MySQL MIN() and MAX() Functions

MySQL MIN() and MAX() Functions

The MIN() and MAX() functions in MySQL are aggregate functions used to find the smallest and largest values in a selected column.

They are commonly used with numeric, date, or even text columns.

✅ MIN() Function

The MIN() function returns the lowest (minimum) value from a column.

Syntax:

🧠 Example Table: students

✅ Example: Find Minimum Marks

✔ Output:

👉 MIN() with Condition

✔ Finds youngest student among those scoring above 80.

🚀 MAX() Function

The MAX() function returns the highest (maximum) value from a column.

Syntax:

✅ Example: Find Maximum Age

✔ Output:

👉 MAX() with Condition

✔ Returns highest marks of students younger than 22.

🧾 MIN() and MAX() with Text Columns

These functions also work on text (alphabetical sorting).

📌 Text comparison follows alphabetical order (A → Z).

📌 Combined Example

You can retrieve both in one query:

🎯 Summary