When you run a select statement the records, or rows, that are displayed are not guaranteed to be in a specific order. Usually, you will want to sort the records to make the report more meaningful. You will learn how to sort records in this topic.
To learn how to sort records in an SQL select statement, follow these steps:
order byclause we can specify that we want the report sorted by ascending city name.
desckeyword to request a descending sort (
ascfor ascending is the default).