Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Sql Sqldate Mysql Date Order

Related Tutorials


 
 

Share on Google+Share on Google+

Mysql Date Order

Advertisement
Mysql Date Order is used to sort the records from a table in ascending order or descending order.

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

If you enjoyed this post then why not add us on Google+? Add us to your Circles



Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: June 16, 2009

Related Tutorials

Discuss: Mysql Date Order  

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:1
Ankit
August 20, 2012
Great

It helped me a lot. Thanks.. very much.
DMCA.com