MySQL ORDER BY Tutorial

ORDER BY u MySQL-u koristimo kod izvlacenja izvestaja kada hocemo da nam podaci budu slozeni po opadajucem ili rastucem kriterijumu.

Na primer, izvlacimo sve podatke iz tabele "kucni", ali tako da ih "slazemo" po imenima (ASC = ASCENDING).

mysql> SELECT * FROM kucni
    -> ORDER BY ime ASC;
+----+---------+-------------+---------+
| id | ime     | prezime     | telefon |
+----+---------+-------------+---------+
|  4 | Marko   | Markovic    |  787878 |
|  2 | Mitar   | Miric       |  111222 |
|  1 | Petar   | Peric       |  444555 |
|  6 | Petar   | Petrovic    |  555555 |
|  5 | Predrag | Predragovic |  333888 |
|  7 | Predrag | Predragovic |  333888 |
|  3 | Zoran   | Zorisic     |  999555 |
+----+---------+-------------+---------+
7 rows in set (0.02 sec)

mysql>

Kada bi hteli da "okrenemo" redosled iz izvestaja, tako da prvi budu zadnji, koristimo ORDER BY kolona DESC, (DESC = DESCENDING).

mysql> SELECT * FROM kucni
    -> ORDER BY ime DESC;
+----+---------+-------------+---------+
| id | ime     | prezime     | telefon |
+----+---------+-------------+---------+
|  3 | Zoran   | Zorisic     |  999555 |
|  5 | Predrag | Predragovic |  333888 |
|  7 | Predrag | Predragovic |  333888 |
|  1 | Petar   | Peric       |  444555 |
|  6 | Petar   | Petrovic    |  555555 |
|  2 | Mitar   | Miric       |  111222 |
|  4 | Marko   | Markovic    |  787878 |
+----+---------+-------------+---------+
7 rows in set (0.00 sec)

mysql>