Filtering data rows
Databases typically contain vast amounts of data. Reports, however, typically use a small subset of the data, so SQL queries often contain filter conditions to limit the rows returned.
How to filter data rows
1 Choose Conditions.
2 Create a filter condition.
1 In Column, select a column or Build Expression to create an expression.
2 In Operator, select an operator.
3 In Value, select a column or type a value.
4 In AND/OR, optionally select AND or OR to specify another filter condition.
Figure 4‑21 Filter condition on data rows
The following WHERE clause is added to the SELECT statement in the top pane:
WHERE CLASSICMODELS.ORDERS.ORDERDATE > '2004-06-30'