Mega Code Archive
To sort in reverse (descending) order
<![CDATA[
/*
mysql> Drop table Bird;
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE TABLE Bird (
-> name VARCHAR(20),
-> owner VARCHAR(20),
-> species VARCHAR(20),
-> sex CHAR(1),
-> birth DATE,
-> death DATE
-> );
Query OK, 0 rows affected (0.04 sec)
mysql> INSERT INTO Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL);
Query OK, 1 row affected (0.01 sec)
mysql> INSERT INTO Bird VALUES ('RedBird','Yin','Bus','m','1979-04-30',NULL);
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO Bird VALUES ('RedBird','Yin','Bus','m','1998-01-30',NULL);
Query OK, 1 row affected (0.00 sec)
mysql> select * from Bird;
+----------+-------+---------+------+------------+-------+
| name | owner | species | sex | birth | death |
+----------+-------+---------+------+------------+-------+
| BlueBird | Joe | Car | f | 1999-03-30 | NULL |
| RedBird | Yin | Bus | m | 1979-04-30 | NULL |
| RedBird | Yin | Bus | m | 1998-01-30 | NULL |
+----------+-------+---------+------+------------+-------+
3 rows in set (0.00 sec)
mysql> /*
mysql> add the DESC keyword to the name of the column you are sorting by:
mysql> */
mysql> SELECT name, birth FROM Bird ORDER BY birth DESC;
+----------+------------+
| name | birth |
+----------+------------+
| BlueBird | 1999-03-30 |
| RedBird | 1998-01-30 |
| RedBird | 1979-04-30 |
+----------+------------+
3 rows in set (0.00 sec)
*/
Drop table Bird;
CREATE TABLE Bird (
name VARCHAR(20),
owner VARCHAR(20),
species VARCHAR(20),
sex CHAR(1),
birth DATE,
death DATE
);
INSERT INTO Bird VALUES ('BlueBird','Joe','Car','f','1999-03-30',NULL);
INSERT INTO Bird VALUES ('RedBird','Yin','Bus','m','1979-04-30',NULL);
INSERT INTO Bird VALUES ('RedBird','Yin','Bus','m','1998-01-30',NULL);
select * from Bird;
/*
add the DESC keyword to the name of the column you are sorting by:
*/
SELECT name, birth FROM Bird ORDER BY birth DESC;
]]>