Getting data out of a table
Getting useful data out of a database table is a challenge that every novice developer struggles with; and quite frankly it is not only inexperienced developers who struggles with this concept, I have see many experienced developers struggle with queries that for some reason was return more information while other return insufficient information.
Now we will examine the structure of an SQL query or SELECT statement. These kind of statements are called “SELECT statements” because they start with the phrase “SELECT” to indicate that the user wants to retrieve information. The general format of the statement is:
SELECT column1, column2, column2
FROM table
WHERE column = condition;
The column list, specifies all columns that you are interested in and the WHERE conditions that each returned row must meet.
For more on SQL select statement, see SQL select queries
Filed under: Uncategorized