Sort the data by clicking
, and then choosing the columns and sort order. The
Generated
SQL statement field shows the sort criteria.
Filter the data by clicking
, and setting the following options:
-
The
Sample tab is used to limit the number of rows to return or to select
distinct values.
-
The
Row Filter table is used to
subset data with a WHERE clause. You can filter on the values in multiple columns, set ranges
for
numeric values, and use IN and NOT IN criteria for
character values. If the number of distinct values is less than 50, then you can select
check boxes for the values. If there are more than 50 distinct values, then you must enter the
values to use for filtering.
-
The Column Filter tab
is used to select the columns to display.