select: Generates Select part fo the query

In mssqlR: MSSQL Querying using R

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)

mssqlR documentation built on May 2, 2019, 10:16 a.m.