In a SELECT query, rows are displayed in an undetermined order. If
you want to guarantee that the rows are returned from a SELECT in a
specific order, you need to add the ORDER BY clause to the end of the
SELECT. Figure shows the use of ORDER
You can ORDER BY more than one column by specifying multiple column names or labels, separated by commas. It would sort by the first column, and for rows with equal values in the first column, it would sort based on the second column specified. Of course, this does not make sense in the the friends example because all columns are unique.