Uses of Class
io.github.torand.fastersql.statement.SelectStatement
Packages that use SelectStatement
Package
Description
Provides classes and interfaces related to predicates.
Provides classes and interfaces related to projections.
Provides classes and interfaces representing relations.
Provides classes and interfaces related to SQL fragments.
Provides classes and interfaces related to statements.
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 SelectStatementModifier and TypeMethodDescriptiondefault 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. -
Uses of SelectStatement in io.github.torand.fastersql.projection
Methods in io.github.torand.fastersql.projection with parameters of type SelectStatementModifier and TypeMethodDescriptionstatic 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 SelectStatementModifier and TypeMethodDescriptionstatic TableSubquery
Relations.table
(SelectStatement query) Creates a table subquery to be used in FROM clauses. -
Uses of SelectStatement in io.github.torand.fastersql.sql
Methods in io.github.torand.fastersql.sql that return types with arguments of type SelectStatementModifier and TypeMethodDescriptionContext.getOuterStatements()
Gets the current outer statements, if any.Methods in io.github.torand.fastersql.sql with parameters of type SelectStatementModifier and TypeMethodDescriptionContext.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 SelectStatementModifier and TypeMethodDescriptionSelectStatement.forUpdate()
Adds a FOR UPDATE clause.Creates a SELECT statement with specified FROM clauses (relations).Adds one or 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.Adds one or more predicates to the HAVING clause.final SelectStatement
Adds one or more predicates to the HAVING clause, if the condition is true.Adds one or more JOIN clauses.final SelectStatement
Adds one or more JOIN clauses, if the condition is true.SelectStatement.leftOuterJoin
(Join join) Adds a LEFT OUTER JOIN clause.SelectStatement.limit
(long limit) Adds a LIMIT clause.SelectStatement.offset
(long offset) Adds a OFFSET clause.Adds one or more ORDER clauses.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.Adds one or more predicates to the WHERE clause.final SelectStatement
Adds supplied predicates to the WHERE clause, if the condition is true. -
Uses of SelectStatement in io.github.torand.fastersql.subquery
Methods in io.github.torand.fastersql.subquery that return SelectStatementModifier and TypeMethodDescriptionExpressionSubquery.query()
Subquery.query()
Gets the SELECT statement of this subquery.TableSubquery.query()
Constructors in io.github.torand.fastersql.subquery with parameters of type SelectStatementModifierConstructorDescriptionCreates an expression subquery.TableSubquery
(SelectStatement query) Creates a table subquery.