Uses of Class
com.exasol.sql.dql.select.Select

Packages that use Select

Package	Description
com.exasol.sql
com.exasol.sql.dql.select
com.exasol.sql.dql.select.rendering
com.exasol.sql.expression
com.exasol.sql.expression.predicate

Uses of Select in com.exasol.sql

Methods in com.exasol.sql that return Select

Modifier and Type	Method	Description
Select	StatementFactory.select()	Create a Select statement.

Uses of Select in com.exasol.sql.dql.select

Methods in com.exasol.sql.dql.select that return Select

Modifier and Type	Method	Description
Select	Select.all()	Add a wildcard field for all involved fields.
Select	Select.arithmeticExpression(BinaryArithmeticExpression arithmeticExpression)	Deprecated. please use a valueExpression(ValueExpression) valueExpression} method instead.
Select	Select.arithmeticExpression(BinaryArithmeticExpression arithmeticExpression, String derivedColumnName)	Deprecated. please use a valueExpression(ValueExpression, String) valueExpression} method instead.
Select	Select.field(String... names)	Add one or more named fields.
Select	Select.function(Function function)	Add a function.
Select	Select.function(FunctionName functionName, ValueExpression... valueExpressions)	Add a function.
Select	Select.function(FunctionName functionName, String derivedColumnName, ValueExpression... valueExpressions)	Add a function.
Select	Select.function(Function function, String derivedColumnName)	Add a function.
Select	GroupByClause.having(BooleanExpression booleanExpression)	Add having statement to the SQL query.
Select	Select.limit(int count)	Create a new full outer LimitClause.
Select	Select.limit(int offset, int count)	Create a new full outer LimitClause.
Select	Select.udf(String functionName, ColumnsDefinition emitsColumnsDefinition, ValueExpression... valueExpressions)	Add a User Defined Function.
Select	Select.udf(String functionName, ValueExpression... valueExpressions)	Add a User Defined Function.
Select	Select.valueExpression(ValueExpression valueExpression)	Add a value expression.
Select	Select.valueExpression(ValueExpression valueExpression, String derivedColumnName)	Add a value expression expression.
Select	Select.where(BooleanExpression expression)	Create a new WhereClause.

Methods in com.exasol.sql.dql.select with parameters of type Select

Modifier and Type	Method	Description
FromClause	FromClause.select(Select select)	Add a select to the FromClause.
void	SelectVisitor.visit(Select select)	Visit the SELECT part of the statement.

Uses of Select in com.exasol.sql.dql.select.rendering

Methods in com.exasol.sql.dql.select.rendering with parameters of type Select

Modifier and Type	Method	Description
void	SelectRenderer.visit(Select select)

Uses of Select in com.exasol.sql.expression

Methods in com.exasol.sql.expression with parameters of type Select

Modifier and Type	Method	Description
static BooleanExpression	BooleanTerm.exists(Select select)	Check if the sub-select has any result.
static BooleanExpression	BooleanTerm.in(ValueExpression operand, Select select)	Check for value sub-select.
static BooleanExpression	BooleanTerm.notIn(ValueExpression operand, Select select)	Check if value not in sub-select.

Uses of Select in com.exasol.sql.expression.predicate

Methods in com.exasol.sql.expression.predicate that return Select

Modifier and Type	Method	Description
Select	ExistsPredicate.getSelectQuery()	Returns the sub select query in the EXISTS predicate.
Select	InPredicate.getSelectQuery()	Returns the sub select query in the [NOT] IN predicate.

Methods in com.exasol.sql.expression.predicate with parameters of type Select

Modifier and Type	Method	Description
InPredicate.Builder	InPredicate.Builder.selectQuery(Select select)	Adds the sub select query.

Constructors in com.exasol.sql.expression.predicate with parameters of type Select

Constructor	Description
ExistsPredicate(Select selectQuery)	Creates a new instance of ExistsPredicate.