Mysql Date Order
Mysql Date Order is used to sort the records from a table in ascending order
or descending order.
Understand with Example
The Tutorial illustrate an example from 'Date Order in Mysql'. To understand
this example, we create a table employee1 with field attribute and data type.
The create table is used to create a table 'employee1'.
Query to create table:-
| CREATE TABLE employee1( Empid int(10),Empname
varchar(60),date date ); |
Output:-
Query to insert data:-
The insert into add the records or rows value to
the table 'employee1'.
mysql> insert into
employee1(Empid,Empname,date)values('01','Girish','2008-12-20');
Query OK, 1 row affected (0.02 sec)
mysql> insert into
employee1(Empid,Empname,date)values('02','Komal','2008-12-21');
Query OK, 1 row affected (0.02 sec)
mysql> insert into
employee1(Empid,Empname,date)values('03','vineet','2008-12-21');
Query OK, 1 row affected (0.03 sec)
mysql> insert into
employee1(Empid,Empname,date)values('04','Amit','2008-12-20');
Query OK, 1 row affected (0.02 sec)
|
Query to view data from the table created:-
mysql> select * from employee1;
|
Output:-
+-------+---------+------------+
| Empid | Empname | date |
+-------+---------+------------+
| 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 |
+-------+---------+------------+
7 rows in set (0.00 sec)
|
Query for viewing the date field in ascending order
using order by:-
The given below syntax return you the sorted records
from a table employee1 on the basis of ascending order.
mysql> select * from employee1 order by date asc;
|
Output:-
+-------+---------+------------+
| Empid | Empname | date |
+-------+---------+------------+
| 1 | Girish | 2008-12-20 |
| 4 | Amit | 2008-12-20 |
| 2 | Komal | 2008-12-21 |
| 3 | vineet | 2008-12-21 |
| 2 | Komal | 2008-12-23 |
| 2 | Sandeep | 2008-12-24 |
| 2 | suman | 2008-12-25 |
+-------+---------+------------+
7 rows in set (0.01 sec)
|
Query for viewing the date field in descending order
using order by:-
The below Query return you the sorted records from a
table by the descending order of field name date.
mysql> select * from employee1 order by date desc;
|
Output:-
+-------+---------+------------+
| Empid | Empname | date |
+-------+---------+------------+
| 2 | suman | 2008-12-25 |
| 2 | Sandeep | 2008-12-24 |
| 2 | Komal | 2008-12-23 |
| 2 | Komal | 2008-12-21 |
| 3 | vineet | 2008-12-21 |
| 1 | Girish | 2008-12-20 |
| 4 | Amit | 2008-12-20 |
+-------+---------+------------+
7 rows in set (0.16 sec)
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
