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 Constructor
SnapObjects.Data.ISqlHavingBuilder
Syntax
public interface ISqlGroupBuilder : ISqlHavingBuilder;
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). |