SQL MIN() and MAX() Functions Explained with Examples | LearnToSAP

SQL TUTORIALS-

SQL MIN() and MAX() Functions Clause

Introduction-

✅ SQL MIN() and MAX() Functions – Easy Examples for Beginners

-✅ SQL MIN() and MAX() functions are aggregate functions used to find the minimum and maximum values in a column...also MIN() function returns the smallest value of the selected column.and MAX() function returns the largest value of the selected column...

🔸 Example Table: Employees

✅ MIN() Function:-MIN() function returns the smallest value in a column.

SELECT MIN(salary) AS LowestSalary
FROM employees;

✅ MAX() Function:-MAX() function returns the largest value in a column.

SELECT MAX(salary) AS HighestSalary
FROM employees;

✅ Combined Example:-

SELECT 
  MIN(salary) AS LowestSalary,
  MAX(salary) AS HighestSalary
FROM employees;

✅Result Show :-

🔸 Example Table: Employees

✅ SQL: Use MIN() with GROUP BY and Set Column Alias.

SELECT Salesperson AS Name,
       Region,
       MIN(Amount) AS Min_Sale
FROM Sales
GROUP BY Salesperson, Region;

May Be Like Important Link-

-SQL Tutorial for Beginners – Introduction to SQL

-SQL TOP, LIMIT, FETCH FIRST or ROWNUM Clause

-SQL SELECT DISTINCT Statement Clause Explained with Examples

-SQL Wildcard Characters: Complete Guide with Examples