Search |
Select by comparing
the source field value using the given Condition
to the given value or values, which can be values
from a field, a specified value, or the result of an expression
that evaluates to a numeric data type.
Condition options:
- between - Select
records with values between the At
least and At
most values, inclusive.
- equal (=) - Select
records with values equal to the given value.
- greater (>)
- Select records with values greater than the given value.
- greater or equal (>=)
- Select records with values greater than or equal to the
given value.
- less (<) - Select
records with values less than the given value.
- less or equal (<=)
- Select records with values less than or equal to the given
value.
- not equal (<>)
- Select records with values not equal to the given value.
If we would like to select records that are NOT variations of
the above, for example not between,
select on the basis of one of the above and press Ctrl-I
or Edit - Select Inverse
to invert the selection. Selecting using between
and then pressing Ctrl-I
is the equivalent of "not between" the given values.
The Round box allows
automatic rounding of the source field number before
comparing to the specified value:
- none - No
rounding.
- down (floor) -
Round down to the next lowest Round to position value. 400.7 would round
down to 400.
-400.7
would round down to -401
(which is a smaller amount, and thus "down," from
400).
- to nearest (round)
- Round up or down to the nearest Round to position value.
When rounding to 1,
a value of 400.5
or greater fraction will get rounded up to 401
while fractional parts less than .5
will get rounded down to 400.
- to zero (trunc)
- Rounding towards zero: Equivalent to rounding down for positive
numbers, and rounding up for negative numbers.
- up (ceil) - Round
up to the next highest Round to position value. 400.2
would round up to 401.
-400.2
would round up to -400
(which is a large amount, and thus "up," from 400).
|
Statistic |
Selects records
based on how large or small their values are relative to other
values in the table:
- maximum - selects
records with the maximum value,
- minimum - selects
records with the minimum value,
- median - selects
records with the median value,
- top - selects the
specified number of records with the largest values,
- bottom - selects
the specified number of records with the smallest values,
- top percent - selects
records with values larger than the specified percentile,
with an option to include or exclude the bounding percentage.
- bottom percent
- selects records with values smaller than the specified
percentile, with an option to include or exclude the bounding
percentage.
|