sql_select: Runs a SQL Select query

In jeffchang5/SQLiter: SQLiteR

Description

Runs a SQL Select query

Usage

sql_select(tbl, cols = "*", where = -1, orderby = -1, orderType = "ASC",
  groupBy = -1, having = -1)

Arguments

tbl	- the table to run the query on
cols	- a vector of the column names you'd like to select, default is all of them
where	- a single string with the where conditions for the query
orderby	- a vector of the column names you'd like to order by in the query
orderType	- the type of ordering (ASC | DESC), DESC is default
groupBy	-a vector of the column names you'd like to group by in the query
having	-a single string with the having conditions for the query

Value

a dataframe with the results of the query

Examples

sql_select(table)
sqL_select(table, c("col1", "col2"), "col1>10 AND col2<10")

jeffchang5/SQLiter documentation built on May 19, 2019, 1:48 a.m.