Package com.github.eikecochu.sqlbuilder

Class GroupBy

java.lang.Object

com.github.eikecochu.sqlbuilder.QueryPartImpl<GroupBy>

com.github.eikecochu.sqlbuilder.GroupBy

All Implemented Interfaces:

BeforeHaving, BeforeOrderBy, BeforeUnion, QueryBuilder, QueryPart

public class GroupBy
extends QueryPartImpl<GroupBy>
implements QueryBuilder, BeforeOrderBy, BeforeHaving, BeforeUnion

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	GroupBy(BeforeGroupBy parent)

Method Summary

Modifier and Type	Method	Description
GroupBy	column(java.lang.String column)	Group by column name
GroupBy	columns(java.lang.String... columns)	Group by column names
java.lang.String	string(QueryOptions options)	Transforms this statement into an SQL string

Methods inherited from class com.github.eikecochu.sqlbuilder.QueryPartImpl

ext, parent, sql

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeHaving

having, having, havingSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeOrderBy

orderBy, orderBy, orderBy, orderBySQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeUnion

union, union, unionAll, unionSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryBuilder

query

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart

string

Constructor Detail

GroupBy

protected GroupBy(BeforeGroupBy parent)

Method Detail

column

public GroupBy column(java.lang.String column)

Group by column name

Parameters:

column - The column name to group by

Returns:

This GROUP BY statement

columns

public GroupBy columns(java.lang.String... columns)

Group by column names

Parameters:

columns - The column names to group by

Returns:

This GROUP BY statement

string

public java.lang.String string(QueryOptions options)

Description copied from interface: QueryPart

Transforms this statement into an SQL string

Specified by:

string in interface QueryPart

Parameters:

options - The QueryOptions to apply for transformation

Returns:

The created SQL string