top: Select top n rows returns a lazy evaluation object, Teradata...

In DyfanJones/connectR: Database backend for DBI, dplyr and dbplyr

Description

top gets the top n of rows from lazy evaluation object and returns a lazy evaluation object.

Usage

top(x = NULL, n = NULL)

Arguments

x:	Lazy evaluation object. Object created from the function 'tbl'.
n:	Number of rows, n defaults to 10.

Value

Returns a lazy evaluation object with n rows from a lazy evaluation object.

Examples

#Top 20 rows from lazy evaluation object
   tbl(post,sql("SELECT * FROM
                 CALENDAR")) %>%
   group_by(ACCOUNT_YEAR_WEEK,
            SEASON) %>%
   summarise(WEEK_ENDING=max(CAL_DATE)) %>%
   top(n=20)

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.