できるPRO MySQL できるPROシリーズ Kindle版の内容をまとめる。
ORDER BY
句ORDER BY 列名 [並び順] [, …]
ASC
(昇順), DESK
(降順)で指定できる。ASC
で実行される。ABCD
を並べた場合,ASC
はAから,DESC
はDからってどっかで読んだな。
De
かい順に並べる。並び順 | 意味 |
---|---|
ASC (ascent) |
昇順(小さいものから) |
DESC (descent) |
降順(大きいものから) |
SELECT * FROM city
ORDER BY Population
LIMIT 5;
MariaDB [world]> SELECT * FROM city ORDER BY Population LIMIT 5;
+------+--------------------+-------------+-------------+------------+
| ID | Name | CountryCode | District | Population |
+------+--------------------+-------------+-------------+------------+
| 2912 | Adamstown | PCN | ? | 42 |
| 2317 | West Island | CCK | West Island | 167 |
| 3333 | Fakaofo | TKL | Fakaofo | 300 |
| 3538 | Citt? del Vaticano | VAT | ? | 455 |
| 2316 | Bantam | CCK | Home Island | 503 |
+------+--------------------+-------------+-------------+------------+
5 rows in set (0.01 sec)
SELECT * FROM city
ORDER BY Population DESC
LIMIT 5;
MariaDB [world]> SELECT * FROM city ORDER BY Population DESC LIMIT 5;
+------+-----------------+-------------+--------------+------------+
| ID | Name | CountryCode | District | Population |
+------+-----------------+-------------+--------------+------------+
| 1024 | Mumbai (Bombay) | IND | Maharashtra | 10500000 |
| 2331 | Seoul | KOR | Seoul | 9981619 |
| 206 | S?o Paulo | BRA | S?o Paulo | 9968485 |
| 1890 | Shanghai | CHN | Shanghai | 9696300 |
| 939 | Jakarta | IDN | Jakarta Raya | 9604900 |
+------+-----------------+-------------+--------------+------------+
5 rows in set (0.01 sec)