sql_gen_select {RSQL}

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.

Author(s)

ken4rab