ISqlGroupBuilder Interface
.NET Standard 2.x
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
Inherited Constructors
SnapObjects.Data.ISqlHavingBuilder
SnapObjects.Data.ISqlOrderBuilder
SnapObjects.Data.ISqlBuilderBase
System.ICloneable<ISqlBuilder>
Syntax
public interface ISqlGroupBuilder : ISqlHavingBuilder, ISqlOrderBuilder, ISqlBuilder, ISqlBuilderBase, ICloneable<ISqlBuilder>;
Method
| 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). |