Package com.exasol.sql.dql.select
Class GroupByClause
- java.lang.Object
-
- com.exasol.sql.AbstractFragment
-
- com.exasol.sql.dql.select.GroupByClause
-
- All Implemented Interfaces:
SelectFragment
,Fragment
public class GroupByClause extends AbstractFragment implements SelectFragment
This class represents the GROUP BY clause of an SQL statement.
-
-
Field Summary
-
Fields inherited from class com.exasol.sql.AbstractFragment
root
-
-
Constructor Summary
Constructors Constructor Description GroupByClause(SqlStatement rootStatement, ColumnReference... columnReferences)
Create a new instance of aGroupByClause
.
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
accept(SelectVisitor visitor)
Accept a visitor (e.g.List<ColumnReference>
getColumnReferences()
Get list of column references.BooleanExpression
getHavingBooleanExpression()
Get the "having" boolean expression.Select
having(BooleanExpression booleanExpression)
Add having statement to the SQL query.-
Methods inherited from class com.exasol.sql.AbstractFragment
getRoot
-
-
-
-
Constructor Detail
-
GroupByClause
public GroupByClause(SqlStatement rootStatement, ColumnReference... columnReferences)
Create a new instance of aGroupByClause
.- Parameters:
rootStatement
- SQL statement thisGROUP BY
clause belongs tocolumnReferences
- column references for theGROUP BY
clause
-
-
Method Detail
-
accept
public void accept(SelectVisitor visitor)
Description copied from interface:SelectFragment
Accept a visitor (e.g. a renderer or validator)- Specified by:
accept
in interfaceSelectFragment
- Parameters:
visitor
- visitor to accept
-
getColumnReferences
public List<ColumnReference> getColumnReferences()
Get list of column references.- Returns:
- column name
-
having
public Select having(BooleanExpression booleanExpression)
Add having statement to the SQL query.- Parameters:
booleanExpression
- boolean expression- Returns:
- instance of
Select
for fluent programming
-
getHavingBooleanExpression
public BooleanExpression getHavingBooleanExpression()
Get the "having" boolean expression.- Returns:
- "having" boolean expression
-
-