Subset rows using column values
This is a method for the dplyr filter() generic. It generates the
WHERE clause of the SQL query.
## S3 method for class 'tbl_lazy' filter(.data, ..., .preserve = FALSE)
.data |
A lazy data frame backed by a database query. |
... |
< |
.preserve |
Not supported by this method. |
Another tbl_lazy. Use show_query() to see the generated
query, and use collect() to execute the query
and return data to R.
library(dplyr, warn.conflicts = FALSE) db <- memdb_frame(x = c(2, NA, 5, NA, 10), y = 1:5) db %>% filter(x < 5) %>% show_query() db %>% filter(is.na(x)) %>% show_query()
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.