MariaDB MIN and MAX Functions


Objectives

  • Understanding of MariaDB MIN and MAX Functions

  • MariaDB MIN Function Exercise

  • MariaDB MAX Function Exercise


Create database and table and insert data if it is not created already

--- Create database if not exist
CREATE DATABASE IF NOT EXISTS mariadb_tutorial;

--- Select the database for further operation
USE mariadb_tutorial;

--- Create table if not exist
CREATE TABLE IF NOT EXISTS person (
    id int(12) NOT NULL AUTO_INCREMENT,
    first_name varchar(150) NOT NULL,
    last_name varchar(150),
    email varchar(100),
    age int,
    income double,
    PRIMARY KEY (id)
)

--- Remove old Data
TRUNCATE person;

--- Insert data into table if not exist
INSERT INTO person (first_name, last_name, email, age, income)
VALUES
	('Faiyaz', 'Mia', 'faiyaz@pf.local', 1, 5000),
	('John', 'Doe', 'john@pf.local', 19, 100),
	('Tahsin', NULL, 'tahsin@pf.local', 10, 150),
	('Jane', 'Doe', 'jane@gmail.com', 26, 300),
	('Rakib', 'Mia', 'rakib@bf.local', 24, 200),
	('Sagor', 'Sowrov', 'email10@bf.local', 20, 250),
	('Touhid', NULL, 'hmtmcse.com@gmail.com', 30, 500);


Understanding of MariaDB MIN and MAX Functions

  • MAX : The MAX() function returns the largest value of the selected column.

  • MIN : The MIN() function returns the smallest value of the selected column.


MariaDB MAX Function Exercise

Problem: Find the maximum income

Syntax

SELECT MAX(column_name) FROM table_name;

Example

SELECT MAX(income) FROM person;

Output

+-------------+
| MAX(income) |
+-------------+
|        5000 |
+-------------+
1 row in set (0.000 sec)


MariaDB MIN Function Exercise

Problem: Find the minimum income

Syntax

SELECT MIN(column_name) FROM table_name;

Example

SELECT MIN(income) FROM person;

Output

+-------------+
| MIN(income) |
+-------------+
|         100 |
+-------------+
1 row in set (0.000 sec)


MariaDB MIN and MAX Functions Video tutorial

Share