Uses of Class
com.gengoai.sql.statement.Select

Packages that use Select

Package	Description
com.gengoai.sql
com.gengoai.sql.object
com.gengoai.sql.sqlite
com.gengoai.sql.statement

Uses of Select in com.gengoai.sql

Methods in com.gengoai.sql with parameters of type Select

Modifier and Type	Method	Description
protected String	SQLDialect.select(@NonNull Select select)	Generates the SQL for select statement

Uses of Select in com.gengoai.sql.object

Methods in com.gengoai.sql.object that return Select

Modifier and Type	Method	Description
Select	Table.select()	Creates a select statement selecting from this table with nothing else specified
Select	Table.select(@NonNull SQLElement... columns)	Creates a select statement selecting from this table returning the specified columns
Select	Table.select(@NonNull String... columns)	Creates a select statement selecting from this table returning the specified columns
Select	Table.selectAll()	Creates a select statement selecting all columns from this table.

Uses of Select in com.gengoai.sql.sqlite

Methods in com.gengoai.sql.sqlite that return Select

Modifier and Type	Method	Description
Select	SQLiteFullTextTable.select()	Creates a select statement selecting from this table with nothing else specified
Select	SQLiteFullTextTable.select(@NonNull SQLElement... columns)	Creates a select statement selecting from this table returning the specified columns
Select	SQLiteFullTextTable.selectAll()	Creates a select statement selecting all columns from this table.

Uses of Select in com.gengoai.sql.statement

Methods in com.gengoai.sql.statement that return Select

Modifier and Type	Method	Description
Select	Select.columns(@NonNull SQLElement... columns)	Sets the columns being selected.
Select	Select.columns(@NonNull Collection<? extends SQLElement> columns)	Sets the columns being selected.
Select	Select.distinct()	Performs a select distinct
Select	Select.distinct(boolean distinct)	Sets whether or not the selct will be distinct
static Select	Select.from(@NonNull SQLElement table)	Creates a new Select statement with the given table for the from clause
static Select	Select.from(@NonNull String table)	Creates a new Select statement with the given table for the from clause
Select	Select.groupBy(@NonNull SQLElement... groupBy)	Sets the group by clause to the given strings.
Select	Select.groupBy(@NonNull String... groupBy)	Sets the group by clause to the given strings.
Select	Select.groupBy(@NonNull Collection<? extends SQLElement> groupBy)	Sets the group by clause to the given strings.
Select	Select.having(SQLElement havingClause)	Sets the criteria for group bys (i.e.
Select	Select.having(String havingClause)	Sets the criteria for group bys (i.e.
Select	Select.innerJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds an inner join with the given table on the given criteria to the from clause
Select	Select.join(@NonNull JoinType type, @NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a join with the given table on the given criteria to the from clause
Select	Select.leftOuterJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a left outer join with the given table on the given criteria to the from clause
Select	Select.limit(SQLElement limitClause)	Sets the limit clause for selection
Select	Select.orderBy(@NonNull SQLElement... orderBy)	Sets the order by clause to the given strings.
Select	Select.orderBy(@NonNull String... orderBy)	Sets the order by clause to the given strings.
Select	Select.orderBy(@NonNull Collection<? extends SQLElement> orderBy)	Sets the order by clause to the given strings.
Select	Select.rightOuterJoin(@NonNull SQLElement table, @NonNull SQLElement criteria)	Adds a right outer join with the given table on the given criteria to the from clause
Select	Select.where(SQLElement whereClause)	Sets the criteria (i.e.
Select	Select.where(String whereClause)	Sets the criteria (i.e.
Select	Select.window(SQLElement window)	Sets the Window function for the selection.
Select	Select.window(String window)	Sets the Window function for the selection.