每日日报

SQL 排序

mysql> use RUNOOB;

Database changed

mysql> SELECT * from runoob_tbl ORDER BY submission_date ASC;

+-----------+---------------+---------------+-----------------+

| runoob_id | runoob_title | runoob_author | submission_date |

+-----------+---------------+---------------+-----------------+

| 3 | 学习 Java | RUNOOB.COM | 2015-05-01 |

| 4 | 学习 Python | RUNOOB.COM | 2016-03-06 |

| 1 | 学习 PHP | 菜鸟教程 | 2017-04-12 |

| 2 | 学习 MySQL | 菜鸟教程 | 2017-04-12 |

+-----------+---------------+---------------+-----------------+

4 rows in set (0.01 sec) mysql> SELECT * from runoob_tbl ORDER BY submission_date DESC;

+-----------+---------------+---------------+-----------------+ |

runoob_id | runoob_title | runoob_author | submission_date | +-----------+---------------+---------------+-----------------+

| 1 | 学习 PHP | 菜鸟教程 | 2017-04-12 |

| 2 | 学习 MySQL | 菜鸟教程 | 2017-04-12 |

| 4 | 学习 Python | RUNOOB.COM | 2016-03-06 |

| 3 | 学习 Java | RUNOOB.COM | 2015-05-01 |

+-----------+---------------+---------------+-----------------+

4 rows in set (0.01 sec)