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.

This article was originally published on Jan 21, 2001
Page 1 of 1

Thanks for your registration, follow us on our social networks to keep up-to-date