@Override public GroupedQueryBuilder groupBy(String... columnNames) { _query.groupBy(columnNames); return this; }
@Override public GroupedQueryBuilder groupBy(String... columnNames) { _query.groupBy(columnNames); return this; }
@Override public void parse(String delim, String itemToken) { _query.groupBy(itemToken); }
@Override public void parse(String delim, String itemToken) { _query.groupBy(itemToken); }
@Override public GroupedQueryBuilder groupBy(Column... columns) { if (columns == null) { throw new IllegalArgumentException("columns cannot be null"); } _query.groupBy(columns); return this; }
@Override public GroupedQueryBuilder groupBy(Column column) { if (column == null) { throw new IllegalArgumentException("column cannot be null"); } _query.groupBy(column); return this; }
@Override public GroupedQueryBuilder groupBy(Column column) { if (column == null) { throw new IllegalArgumentException("column cannot be null"); } _query.groupBy(column); return this; }
@Override public GroupedQueryBuilder groupBy(Column... columns) { if (columns == null) { throw new IllegalArgumentException("columns cannot be null"); } _query.groupBy(columns); return this; }
public Query groupBy(String... groupByTokens) { for (String groupByToken : groupByTokens) { SelectItem selectItem = findSelectItem(groupByToken, true); groupBy(new GroupByItem(selectItem)); } return this; }
public Query groupBy(String... groupByTokens) { for (String groupByToken : groupByTokens) { SelectItem selectItem = findSelectItem(groupByToken, true); groupBy(new GroupByItem(selectItem)); } return this; }
Query q = new Query().select(foreignColumns).select(countAllItem).from(table).groupBy( foreignColumns); DataSet data = executeQuery(q);
@Override public Query clone() { final Query q = new Query(); q.setMaxRows(_maxRows); q.setFirstRow(_firstRow); q.getSelectClause().setDistinct(_selectClause.isDistinct()); for (FromItem item : _fromClause.getItems()) { q.from(item.clone()); } for (SelectItem item : _selectClause.getItems()) { q.select(item.clone(q)); } for (FilterItem item : _whereClause.getItems()) { q.where(item.clone()); } for (GroupByItem item : _groupByClause.getItems()) { q.groupBy(item.clone()); } for (FilterItem item : _havingClause.getItems()) { q.having(item.clone()); } for (OrderByItem item : _orderByClause.getItems()) { q.orderBy(item.clone()); } return q; } }
@Override public Query clone() { final Query q = new Query(); q.setMaxRows(_maxRows); q.setFirstRow(_firstRow); q.getSelectClause().setDistinct(_selectClause.isDistinct()); for (FromItem item : _fromClause.getItems()) { q.from(item.clone()); } for (SelectItem item : _selectClause.getItems()) { q.select(item.clone(q)); } for (FilterItem item : _whereClause.getItems()) { q.where(item.clone()); } for (GroupByItem item : _groupByClause.getItems()) { q.groupBy(item.clone()); } for (FilterItem item : _havingClause.getItems()) { q.having(item.clone()); } for (OrderByItem item : _orderByClause.getItems()) { q.orderBy(item.clone()); } return q; } }