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