Mysql Min Max

Mysql Min Max is useful to find the minimum and maximum records from a table.

Mysql Min Max

Mysql Min Max

     

Mysql Min Max is useful to find the minimum and maximum records from a table.

Understand with Example

The Tutorial illustrate an example from Mysql Min Max. To understand and grasp the example we create a table 'employee' with required fieldnames and datatypes respectively. 

Query for creating table name Employee:

mysql> CREATE TABLE Employee(
    ->              Empid int(10),
    ->              Empname varchar(60),
    ->              Salary int(90),
    ->              DOB date
    ->            );
Query OK, 0 rows affected (0.01 sec)

Query for  insertion of data in table:

The Query insert into is used to add the records or rows value to the table 'employee'.

mysql>     INSERT INTO Employee (Empid,Empname,Salary,DOB) VALUES
    ->     (01,'Habib',2014,20041202),
    ->     (02,'Karan',4021,20030411),
    ->     (03,'Samia', 22,20080223),
    ->     (04,'Hui Ling', 25,20081015),
    ->     (05,'Yumie', 29,19990126);
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

Query to view data inserted in table:

The Query is used to view the records from table 'employee'.

mysql> select * from employee;

Output:-

+-------+----------+--------+------------+
| Empid | Empname  | Salary | DOB        |
+-------+----------+--------+------------+
|     1 | Habib    |   2014 | 2004-12-02 |
|     2 | Karan    |   4021 | 2003-04-11 |
|     3 | Samia    |     22 | 2008-02-23 |
|     4 | Hui Ling |     25 | 2008-10-15 |
|     5 | Yumie    |     29 | 1999-01-26 |
+-------+----------+--------+------------+
5 rows in set (0.00 sec)

The Query below is  used to  find minimum  salary from the table employee.

mysql> select min(salary)as MinSalary from employee;
+-----------+
| MinSalary |
+-----------+
|        22 |
+-----------+
1 row in set (0.00 sec)

The Query below  to find maximum salary from the table employee.

mysql> select max(salary)as MaxSalary from employee;
+-----------+
| MaxSalary |
+-----------+
|      4021 |
+-----------+
1 row in set (0.00 sec)