SELECT column name(s) FROM table name(s) [WHERE search_condition] [GROUP BY group_list] [HAVING search_condition] [ORDER BY order_list];
|( )||parentheses (force order of evaluation)|
|>=||greater than or equal|
|<=||less than or equal|
|BETWEEN||expression1 AND expression2|
This tutorial discussed how to express many commonly asked business questions as SELECT statements and how to retrieve, group, and order data selected from relational tables.
Most questions discussed in this tutorial are easily expressed as standard SELECT statements and challenge neither the user nor SQL. The remaining tutorials of this series address more difficult questions, questions that require sequential processing, comparisons of aggregated values, more complex join specifications, or lengthy SELECT statements.
Before moving on to the next part, you should go to the DB2 Information Center and read the full online documentation on the SELECT statement. This will help you become familiar with the format of the help documentation and review what you have just learned.