Overview
In addition to variable subsetting, RDS also supports comprehensive and complex record subsetting. This is done though the where parameter. The where clause is similar to that of a relational database where users can specify logical operations that will be evaluated to subset the data set.
Supported Where Functions
| Name | Operator |
|---|---|
| Greater than or equal to | >= |
| Greater than | > |
| Equal to | = |
| Less than | < |
| Less than or equal to | <= |
| Not equal to | != |
| Like a particular value | like |
| Matches a regular expression | matches |
Step By Step