Ordering

select * from r order by attribute [asc/desc]

Ascending order is default.

It can also sort given a list of attributes.