sql_gen_select | R Documentation |
Generates a Select Statement
sql_gen_select(
select_fields,
table,
where_fields = names(where_values),
where_values = NULL,
group_by = c(),
order_by = c(),
top = 0,
distinct = FALSE
)
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. |
ken4rab
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.