Select  Numeric Vectors
Select templates for numeric vectors, that is fields with ordered sets
of multiple numbers, that is a field with an ordered set of multiple numbers,
of x2 (two numbers), x3 (three numbers), or x4 (four numbers). Click
on a template's link to jump to that template's topic.
Expression 
Select using the
given expression. 
Null 
Select for null
values in the source field.
 null  Select records
with NULL values.
 not null  Select
records with nonNULL values.

Search 
Select by making
comparisons against the desired extraction from the numeric vector
field specified in the Use
parameter, using the given Condition,
compared 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 value or to a datetime value depending
on the data type of the extraction specified in the Use
parameter.
Use options:
 value 0  Use the
first component of the vector.
 value 1  Appears
with x2, x3 and x4 types. Use the second component of
the vector.
 value 2  Appears
with x3 and x4 types. Use the third component of the
vector.
 value 3  Appears
with x4 types. Use the fourth component of the vector.
 vector  Use
the vector value in the source field.
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 CtrlI
or Edit  Select Inverse
to invert the selection. Selecting using between
and then pressing CtrlI
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.
Numeric vector order is computed based on the first component
being the most significant, followed by the second component in
the event of a tie in the first component, followed by the third
component, and so on.

Unique 
Selects records
based on how many times their values occur in a table:
 duplicate  for
each duplicate value, selects all such records except one,
 nonunique  selects
records for values that occur more than once,
 unique  selects
records for values that occur only once.

Notes
Numeric vector types  Numeric
vectors are fields that have ordered sets of multiple numbers, of x2 type
float32x2, float64x2,
int8x2, int16x2,
int32x2, int64x2, uint8x2, uint16x2,
uint32x2, uint6x2,
of x3 type float32x3, float64x3,
int8x3, int16x3,
int32x3, int64x3, uint8x3, uint16x3,
uint32x3, uint6x3,
or of x4 type float32x4, float64x4, int8x4,
int16x4, int32x4,
int64x4, uint8x4,
uint16x4, uint32x4,
uint6x4.
See Also
Select
 Numeric Vectors: Expression
Select
 Numeric Vectors: Null
Select
 Numeric Vectors: Search
Select
 Numeric Vectors: Statistic
Select
 Numeric Vectors: Unique
Select Reference
Select
 Expression
Select  Binary
Select  Boolean
Select 
Datetime
Select 
Geometry
Select  Numbers
Select  Text
Select  Tiles
Select  UUID