arrange.tbl_lazy {dbplyr}R Documentation

Arrange rows by column values


This is an method for the dplyr arrange() generic. It generates the ORDER BY clause of the SQL query. It also affects the window_order() of windowed expressions in mutate.tbl_lazy().

Note that ORDER BY clauses can not generally appear in subqueries, which means that you should arrange() as late as possible in your pipelines.


## S3 method for class 'tbl_lazy'
arrange(.data, ..., .by_group = FALSE)



A lazy data frame backed by a database query.


<data-masking> Variables, or functions of variables. Use desc() to sort a variable in descending order.


If TRUE, will sort first by grouping variable. Applies to grouped data frames only.


Another tbl_lazy. Use show_query() to see the generated query, and use collect() to execute the query and return data to R.

Missing values

Unlike R, most databases sorts NA (NULLs) at the front. You can can override this behaviour by explicitly sorting on


library(dplyr, warn.conflicts = FALSE)

db <- memdb_frame(a = c(3, 4, 1, 2), b = c(5, 1, 2, NA))
db %>% arrange(a) %>% show_query()

# Note that NAs are sorted first
db %>% arrange(b)
# override by sorting on first
db %>% arrange(, b)

[Package dbplyr version 2.1.1 Index]