mssqlR (version 1.0.0)

select: Generates Select part fo the query

Description

This function creates "Select" part fo the query

Usage

select(query = NULL, ..., top = NULL, distinct = NULL)

Arguments

query

Existing query

...

Fields to query

top

Top n rows of the data

distinct

True or FALSE

Examples

#Returns Top 100 rows
from_tb <- select("","COl1","COl2","Col3", top=100)

#Returns distinct rows
from_tb <- select("","COl1","COl2","Col3", distinct=TRUE)