Uses of Class
io.github.torand.fastersql.statement.SelectStatement

Packages that use SelectStatement

Package	Description
io.github.torand.fastersql.predicate	Provides classes and interfaces related to predicates.
io.github.torand.fastersql.projection	Provides classes and interfaces related to projections.
io.github.torand.fastersql.relation	Provides classes and interfaces representing relations.
io.github.torand.fastersql.setoperation	Provides classes representing set operations.
io.github.torand.fastersql.sql	Provides classes and interfaces related to SQL fragments.
io.github.torand.fastersql.statement	Provides classes and interfaces related to statements.
io.github.torand.fastersql.subquery	Provides classes and interfaces related to subqueries.

Uses of SelectStatement in io.github.torand.fastersql.predicate

Methods in io.github.torand.fastersql.predicate with parameters of type SelectStatement

Modifier and Type	Method	Description
default Predicate	LeftOperand.eq(SelectStatement query)	Creates an equivalence predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.ge(SelectStatement query)	Creates a 'greater than or equal' predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.gt(SelectStatement query)	Creates a 'greater than' predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.in(SelectStatement query)	Creates a 'member of set' predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.le(SelectStatement query)	Creates a 'less than or equal' predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.lt(SelectStatement query)	Creates a 'less than' predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.ne(SelectStatement query)	Creates a non-equivalence predicate from this left operand and the specified subquery.
default Predicate	LeftOperand.notIn(SelectStatement query)	Creates a 'not member of set' predicate from this left operand and the specified subquery.

Uses of SelectStatement in io.github.torand.fastersql.projection

Methods in io.github.torand.fastersql.projection with parameters of type SelectStatement

Modifier and Type	Method	Description
static ExpressionSubquery	Projections.subquery(SelectStatement query)	Creates a subquery expression to be used as a projection.

Uses of SelectStatement in io.github.torand.fastersql.relation

Methods in io.github.torand.fastersql.relation with parameters of type SelectStatement

Modifier and Type	Method	Description
static TableSubquery	Relations.table(SelectStatement query)	Creates a table subquery to be used in FROM clauses.

Uses of SelectStatement in io.github.torand.fastersql.setoperation

Methods in io.github.torand.fastersql.setoperation that return SelectStatement

Modifier and Type	Method	Description
SelectStatement	SetOperation.operand()	Gets the operand of this set operation.

Constructors in io.github.torand.fastersql.setoperation with parameters of type SelectStatement

Modifier	Constructor	Description
	SetOperation(SelectStatement operand, SetOperator operator)	Creates a set operation clause.

Uses of SelectStatement in io.github.torand.fastersql.sql

Methods in io.github.torand.fastersql.sql that return types with arguments of type SelectStatement

Modifier and Type	Method	Description
List<SelectStatement>	Context.getOuterStatements()	Gets the current outer statements, if any.

Methods in io.github.torand.fastersql.sql with parameters of type SelectStatement

Modifier and Type	Method	Description
Context	Context.withOuterStatement(SelectStatement outerStatement)	Sets the current outer statement.

Uses of SelectStatement in io.github.torand.fastersql.statement

Methods in io.github.torand.fastersql.statement that return SelectStatement

Modifier and Type	Method	Description
SelectStatement	SelectStatement.forUpdate()	Adds a FOR UPDATE clause.
SelectStatement	SelectFromBuilder.from(Relation firstRelation, Relation... moreRelations)	Creates a SELECT statement with specified FROM clauses (relations).
SelectStatement	SelectStatement.fullOuterJoin(Join join)	Adds a FULL OUTER JOIN clause.
SelectStatement	SelectStatement.groupBy(Column... groups)	Adds one or more columns as groups to the GROUP BY clause.
final SelectStatement	SelectStatement.having(OptionalPredicate... maybePredicates)	Adds optional predicates to the HAVING clause if the wrapped predicates are present.
SelectStatement	SelectStatement.having(Predicate... predicates)	Adds one or more predicates to the HAVING clause.
final SelectStatement	SelectStatement.havingIf(boolean condition, Supplier<Predicate>... predicateSuppliers)	Adds one or more predicates to the HAVING clause, if the condition is true.
SelectStatement	SelectStatement.join(Join... joins)	Adds one or more JOIN clauses.
final SelectStatement	SelectStatement.joinIf(boolean condition, Supplier<Join>... joinSuppliers)	Adds one or more JOIN clauses, if the condition is true.
SelectStatement	SelectStatement.leftOuterJoin(Join join)	Adds a LEFT OUTER JOIN clause.
SelectStatement	SelectStatement.limit(long limit)	Adds a LIMIT clause.
SelectStatement	SelectStatement.offset(long offset)	Adds a OFFSET clause.
SelectStatement	SelectStatement.orderBy(Order... orders)	Adds one or more ORDER clauses.
SelectStatement	SelectStatement.rightOuterJoin(Join join)	Adds a RIGHT OUTER JOIN clause.
final SelectStatement	SelectStatement.where(OptionalPredicate... maybePredicates)	Adds optional predicates to the WHERE clause if the wrapped predicates are present.
SelectStatement	SelectStatement.where(Predicate... predicates)	Adds one or more predicates to the WHERE clause.
final SelectStatement	SelectStatement.whereIf(boolean condition, Supplier<Predicate>... predicateSuppliers)	Adds supplied predicates to the WHERE clause, if the condition is true.

Methods in io.github.torand.fastersql.statement with parameters of type SelectStatement

Modifier and Type	Method	Description
SelectSetOpStatement	SelectSetOpStatement.except(SelectStatement operand)	Creates an EXCEPT set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.except(SelectStatement other)	Creates an EXCEPT set operation between this and the specified statement.
SelectSetOpStatement	SelectSetOpStatement.exceptAll(SelectStatement operand)	Creates an EXCEPT ALL set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.exceptAll(SelectStatement other)	Creates an EXCEPT ALL set operation between this and the specified statement.
SelectSetOpStatement	SelectSetOpStatement.intersect(SelectStatement operand)	Creates an INTERSECT set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.intersect(SelectStatement other)	Creates an INTERSECT set operation between this and the specified statement.
SelectSetOpStatement	SelectSetOpStatement.intersectAll(SelectStatement operand)	Creates an INTERSECT ALL set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.intersectAll(SelectStatement other)	Creates an INTERSECT ALL set operation between this and the specified statement.
SelectSetOpStatement	SelectSetOpStatement.union(SelectStatement operand)	Creates a UNION set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.union(SelectStatement other)	Creates a UNION set operation between this and the specified statement.
SelectSetOpStatement	SelectSetOpStatement.unionAll(SelectStatement operand)	Creates a UNION ALL set operation between this and the specified statement.
SelectSetOpStatement	SelectStatement.unionAll(SelectStatement other)	Creates a UNION ALL set operation between this and the specified statement.

Uses of SelectStatement in io.github.torand.fastersql.subquery

Methods in io.github.torand.fastersql.subquery that return SelectStatement

Modifier and Type	Method	Description
SelectStatement	ExpressionSubquery.query()
SelectStatement	Subquery.query()	Gets the SELECT statement of this subquery.
SelectStatement	TableSubquery.query()

Constructors in io.github.torand.fastersql.subquery with parameters of type SelectStatement

Modifier	Constructor	Description
	ExpressionSubquery(SelectStatement query)	Creates an expression subquery.
	TableSubquery(SelectStatement query)	Creates a table subquery.