ISqlGroupBuilder Interface

.NET Standard 2.x | Current Version (1.0.1)

Represents an object used to create a GROUP BY clause.

A GROUP BY clause is a clause in the SELECT statement that divides the query result into groups of rows.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

System.ICloneable<ISqlBuilder>

   public interface ISqlGroupBuilder : ISqlHavingBuilder, ISqlOrderBuilder, ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;

Name	Return Type	Description
AsHaving()	ISqlHavingAndOr	Returns an ISqlHavingAndOr object that can be used to add a search condition to a group or an aggregate in the HAVING clause.
GroupBy(params string[] groupExpressions)	ISqlGroupBuilder	Creates a GROUP BY clause and adds an array of SQL expressions (each expression specifies a column or a non-aggregate calculation on a column).
GroupBy(string groupClause)	ISqlGroupBuilder	Creates a GROUP BY clause, and adds a raw SQL string containing one or more column expressions (each expression specifies a column or a non-aggregate calculation on a column).