This is a method for the dplyr distinct()
generic. It adds the
DISTINCT
clause to the SQL query.
# S3 method for tbl_lazy distinct(.data, ..., .keep_all = FALSE)
.data | A lazy data frame backed by a database query. |
---|---|
... | < |
.keep_all | If |
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(1, 1, 2, 2), y = c(1, 2, 1, 1)) db %>% distinct() %>% show_query()#> <SQL> #> SELECT DISTINCT * #> FROM `dbplyr_012`#> <SQL> #> SELECT DISTINCT `x` #> FROM `dbplyr_012`