“Of course, the whole idea of structuring data into rows and
columns is to make it easier to get a focused result set. And a
great part of that focus comes from the WHERE clause (maybe you
remember this from the UPDATE and DELETE statements you learnt last
time) to the SELECT statement, which allows you to define specific
criteria for the result set. Records that do not meet the specified
criteria will not appear in the result set.”
“… If you’d like to see the data from your table ordered by a
specific field, SQL offers the ORDER BY construct. This construct
allows you to specify both the column name and the direction in
which you would like to see data (ascending or descending).”