class

Focus::SelectStatement

Inherits Focus::Statement / Focus::Queryable / Reference / Object

Constructors

new(select_clause : Focus::SelectClause)

Instance methods

aliased(label : String) : Focus::SelectTable

as_cte(label : String) : Focus::CommonTableExpression

distinct

from(table : Focus::ReadableTable) : self

from_clause

from_clause=(from_clause : Focus::FromClause | Nil)

group_by(*columns : Focus::Column) : self

group_by_clause

group_by_clause=(group_by_clause : Focus::GroupByClause | Nil)

having(expression : Focus::BoolExpression) : self

having_clause

having_clause=(having_clause : Focus::HavingClause | Nil)

limit(limit : Int32) : self

limit_clause

limit_clause=(limit_clause : Focus::LimitClause | Nil)

offset(offset : Int32) : self

offset_clause

offset_clause=(offset_clause : Focus::OffsetClause | Nil)

order_by(*clauses : Focus::OrderByClause) : self

order_by_clauses

order_by_clauses=(order_by_clauses : Focus::OrderByListClause | Nil)

ordered_clauses

select_clause

statement_type

where(expression : Focus::BoolExpression) : self

where_clause

where_clause=(where_clause : Focus::WhereClause | Nil)