ADSQLSelectInstruction

public struct ADSQLSelectInstruction: ADSQLInstruction

Holds all information about a SQL SELECT instruction.

  • If true, a distince set of values will be returned, else false.

    Declaration

    Swift

    public var distinct: Bool = false
  • The list of columns returned by this select statement.

    Declaration

    Swift

    public var columns: [ADSQLResultColumn] = []
  • The source table (or tables) that the columns are read from.

    Declaration

    Swift

    public var fromSouce: ADSQLJoinClause = ADSQLJoinClause()
  • The WHERE clause defining which table rows should be returned. If this expression if nil, all rows will be returned.

    Declaration

    Swift

    public var whereExpression: ADSQLExpression?
  • An optional GROUP BY clause used to group the results of the SELECT statement.

    Declaration

    Swift

    public var groupByColumns: [String] = []
  • An optional HAVING clause to control when specific columns should be grouped.

    Declaration

    Swift

    public var havingExpression: ADSQLExpression?
  • An optional group of columns used to sort the resulting table rows.

    Declaration

    Swift

    public var orderBy: [ADSQLOrderByClause] = []
  • Defines the maximum number of rows returned. If -1, all rows will be returned.

    Declaration

    Swift

    public var limit: Int = -1
  • Defines an offest from the first row to start returning rows for. If -1, the results start with the first row.

    Declaration

    Swift

    public var offset: Int = -1