DevShed: Speaking SQL (Part 2)

“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).”

… I hope this introduction to SQL helped you get some idea of how to go about creating
and using a database, and that you now have a better understanding of the language.