SQL MIN() and MAX() Functions Clause

SQL TUTORIALS-

SQL MIN() and MAX() Functions Clause

Introduction-

-✅ 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-

-Chart Of Account-OB13

-Define Plant-OX1

-Chart Of Account-OB13

-Define Financial Statement