About

order by is a query clause that will sort the records (row) according to a collation.

Example

select firstname, lastname from user order by creation_date DESC