This is a shortcut for x >= left & x <= right, implemented efficiently in C++ for local values, and translated to the appropriate SQL for remote tables.
x >= left & x <= right
between(x, left, right)
A numeric vector of values
Boundary values (must be scalars).
between(1:12, 7, 9) x <- rnorm(1e2) x[between(x, -1, 1)] ## Or on a tibble using filter filter(starwars, between(height, 100, 150))
Run the code above in your browser using DataLab