Mysql Max Date
Mysql Max Date is used to return the maximum value of date from a table.
Understand with Example
The Tutorial illustrate an example from 'Mysql Max Date'.To grasp this example we create a table employee1 with required fieldname and datatype.
Query to Create Table named employee1:
mysql>CREATE TABLE employee1 ( -> Empid int(10), -> Empname varchar(60), -> date date -> ); |
Query to insert data into Table named employee1:
The Query insert into is used to add the records or rows into a table 'employee1'.
mysql>insert into employee1 values(01,'Girish','2008-12-20'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(02,'Komal','2008-12-21'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(03,'vineet','2008-12-21'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(04,'Amit','2008-12-20'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(02,'Komal','2008-12-23'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(02,'Sandeep','2008-12-24'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(02,'suman','2008-12-25'); Query OK, 1 row affected (0.02 sec) mysql>insert into employee1 values(01,'AAA',' 2008-12-03'); Query OK, 1 row affected (0.02 sec) |
Query to view data of Table named employee1:
mysql> select * from employee1; +-------+---------+------------+ | Empid | Name | DOB | +-------+---------+------------+ | 1 | Girish | 2008-12-20 | | 2 | Komal | 2008-12-21 | | 3 | vineet | 2008-12-21 | | 4 | Amit | 2008-12-20 | | 2 | Komal | 2008-12-23 | | 2 | Sandeep | 2008-12-24 | | 2 | suman | 2008-12-25 | | 1 | AAA | 2008-12-03 | +-------+---------+------------+ 8 rows in set (0.01 sec) |
Query to view max date from column DOB of Table named employee1:
The Query below max(DOB) is used to return the maximum value from DOB as fieldname MAXDATE from employee1.
mysql> select max(DOB)as MAXDATE from employee1; |
Output:-
+------------+ | MAXDATE | +------------+ | 2008-12-25 | +------------+ 1 row in set (0.00 sec) |