August 20th, 2008

Column and Row Selection

Posted by admin in D. WHERE Clause

The column names are used to select only those columns.
The WHERE clause is used to specify the rows you wish to retrieve.
If we use both, then we retrieve only the columns and rows we need.

SELECT column1, column2, ...
  FROM table1, table2, ...
 WHERE condition1, condition2, ...;

Comments are closed.

Sorry, the comment form is closed at this time.