|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectgudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.nodes.TGroupBy
public class TGroupBy
This class represents group by clause and having clause.
Specify the GROUP BY clause if you want the database to group the selected rows based on the value of expr(s) for each row and return a single row of summary information for each group.
If this clause contains CUBE or ROLLUP extensions, then the database produces superaggregate groupings in addition to the regular groupings.
Use the HAVING clause to restrict the groups of returned rows to those groups for which the specified condition is TRUE. If you omit this clause, then the database returns summary rows for all groups.
Constructor Summary | |
---|---|
TGroupBy()
|
Method Summary | |
---|---|
void |
accept(TParseTreeVisitor v)
|
void |
doParse(TCustomSqlStatement psql,
ESqlClause plocation)
analyze this node |
TExpression |
getHavingClause()
Restrict the groups of returned rows to those groups for which the specified condition is TRUE. |
TGroupByItemList |
getItems()
|
void |
init(java.lang.Object arg1,
java.lang.Object arg2)
|
Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode |
---|
addAllMyTokensToTokenList, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, setDummyTag, setEndToken, setEndToken, setGsqlparser, setNodeType, setStartToken, setStartToken, setString, toString |
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait |
Constructor Detail |
---|
public TGroupBy()
Method Detail |
---|
public TExpression getHavingClause()
If you omit this clause, then the database returns summary rows for all groups.
public TGroupByItemList getItems()
TExpression
,
TRollupCube
,
TGroupingSet
public void init(java.lang.Object arg1, java.lang.Object arg2)
init
in class TParseTreeNode
public void doParse(TCustomSqlStatement psql, ESqlClause plocation)
TParseTreeNode
doParse
in class TParseTreeNode
public void accept(TParseTreeVisitor v)
accept
in interface Visitable
accept
in class TParseTreeNode
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |