sqlForSelect: Generate SQL SELECT statement#'

In KWB-R/kwb.db: Functions supporting data base access

Generate SQL SELECT statement#'

Description

Generate SQL SELECT statement#'

Usage

sqlForSelect(
  tablename,
  fields = "*",
  whereClause = "TRUE",
  groupBy = "",
  orderBy = "",
  sqlDialect = getCurrentSqlDialect()
)

Arguments

tablename	table name
fields	expression to select fields; field names are separated by comma and alias names may be used, just as SQL accepts, e.g.: "tstamp as myDateTime, parVal as myValue"; Default: "*"
whereClause	where condition; Default: "TRUE"
groupBy	GROUP BY-clause, Default: "" (no grouping)
orderBy	ORDER BY-clause, Default: "" (no sorting of results)
sqlDialect	one of c("mysql", "msaccess")

KWB-R/kwb.db documentation built on Oct. 1, 2023, 4:10 a.m.