How to order a database result-set?

The SQL language has the ORDER BY keyphrase for ordering a result-set.

The Zend_Db_Select class has the order() method for it:

An example