"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)."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.