Nothing
Code
test_translate_sql(sum(x, na.rm = TRUE), vars_frame = c(1, 0))
Condition
Warning:
Windowed expression `SUM(`x`)` does not have explicit order.
i Please use `arrange()` or `window_order()` to make deterministic.
Error in `rows()`:
! `from` (1) must be less than `to` (0)
Code
test_translate_sql(row_number(c(x)))
Condition
Error in `row_number()`:
! Can't use `c()` in `ROW_NUMBER()`
i Did you mean to use `tibble(x)` instead?
Code
mf %>% mutate(rown = row_number())
Output
<SQL>
SELECT `df`.*, ROW_NUMBER() OVER () AS `rown`
FROM `df`
Code
mf %>% group_by(y) %>% mutate(rown = row_number())
Output
<SQL>
SELECT `df`.*, ROW_NUMBER() OVER (PARTITION BY `y`) AS `rown`
FROM `df`
Code
mf %>% group_by(y) %>% arrange(y) %>% mutate(rown = row_number())
Output
<SQL>
SELECT `df`.*, ROW_NUMBER() OVER (PARTITION BY `y` ORDER BY `y`) AS `rown`
FROM `df`
ORDER BY `y`
Code
mf %>% arrange(y) %>% mutate(rown = row_number())
Output
<SQL>
SELECT `df`.*, ROW_NUMBER() OVER (ORDER BY `y`) AS `rown`
FROM `df`
ORDER BY `y`
Code
lf %>% window_frame(-3, 0) %>% window_order(x) %>% mutate(z = sum(y, na.rm = TRUE)) %>%
show_query()
Output
<SQL>
SELECT `df`.*, SUM(`y`) OVER (ORDER BY `x` ROWS 3 PRECEDING) AS `z`
FROM `df`
Code
lf %>% window_frame(-3) %>% window_order(x) %>% mutate(z = sum(y, na.rm = TRUE)) %>%
show_query()
Output
<SQL>
SELECT
`df`.*,
SUM(`y`) OVER (ORDER BY `x` ROWS BETWEEN 3 PRECEDING AND UNBOUNDED FOLLOWING) AS `z`
FROM `df`
Code
window_frame(lf, "a")
Condition
Error in `window_frame()`:
! `from` must be a whole number, not the string "a".
Code
window_frame(lf, 1:2)
Condition
Error in `window_frame()`:
! `from` must be a whole number, not an integer vector.
Code
window_frame(lf, 1, "a")
Condition
Error in `window_frame()`:
! `to` must be a whole number, not the string "a".
Code
window_frame(lf, 1, 1:2)
Condition
Error in `window_frame()`:
! `to` must be a whole number, not an integer vector.
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.