sql_gen_select: sql_gen_select
In RSQL: Database Agnostic Package to Generate and Process 'SQL' Queries in R

sql_gen_select

R Documentation

sql_gen_select

Description

Generates a Select Statement

Usage

sql_gen_select(
  select_fields,
  table,
  where_fields = names(where_values),
  where_values = NULL,
  group_by = c(),
  order_by = c(),
  top = 0,
  distinct = FALSE
)

Arguments

`select_fields`	The fields to be selected
`table`	The table to be used in the select
`where_fields`	The fields used in the where section
`where_values`	The values used in the where section
`group_by`	Group by fields
`order_by`	Order by fields
`top`	Retrieve top records
`distinct`	it adds a distinct clause to the query.