ISqlHavingBuilder Interface

.NET Standard 2.x

Represents an object used to build a HAVING clause of a SQL statement.

The HAVING clause specifies the search condition for a group or an aggregate.

Namespace: SnapObjects.Data

Assembly: SnapObjects.Data.dll

Inherited Constructor

SnapObjects.Data.ISqlOrderBuilder

Syntax

public interface ISqlHavingBuilder : ISqlOrderBuilder;

Methods

Name	Return Type	Description
AsOrderBy()	ISqlHavingAndOr	Returns an `ISqlOrderThenBuilder` object which can be used to add sorting criteria to the ORDER clause.
Having(string left, ISqlParameter parameter)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a search condition to the `HAVING` clause. You can specify a SQL expression on the left of the operator and a SQL parameter on the right of the operator. The operator is '='.
Having(string left, SqlBinaryOperator sqlOperator, ISqlParameter parameter)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a search condition to the `HAVING` clause. You can specify a SQL expression on the left of the operator and a SQL parameter on the right of the operator.
Having(string left, string right)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a search condition to the `HAVING` clause. You can specify SQL expressions on both the left and right of the operator. The operator is '='.
Having(string left, SqlBinaryOperator sqlOperator, string right)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a search condition to the `HAVING` clause. You can specify a SQL expression on the left of the operator and a SQL subquery on the right side. The operator is '='.
Having(string left, ISqlBuilder sqlBuilder)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a search condition to the `HAVING` clause. Specifies a SQL expression on the left of the operator and specifies a SQL subquery on the right side. The operator is '='.
Having(string left, SqlBinaryOperator sqlOperator, ISqlBuilder sqlBuilder)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a search condition to the `HAVING` clause. You can specify a SQL expression on the left of the operator and a SQL subquery on the right side.
Having(ISqlHavingCondition condition)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a search condition to the `HAVING` clause by an `ISqlHavingCondition` object.
Having(ISqlHavingCondition condition, string havingName)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a search condition to the `HAVING` clause by an `ISqlHavingCondition` object and specifies the name for the search condition.
HavingRaw(string havingClause, params ISqlParameter[] parameters)	ISqlHavingAndOr	Creates a `HAVING` clause and adds a raw SQL to the `HAVING` clause.
HavingRaw(string havingClause, string havingName, params ISqlParameter[] parameters)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a raw SQL to the `HAVING` clause and specifies a name for the raw SQL.
HavingValue(string left, object value)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a search condition to the `HAVING` clause. You can specify a SQL expression on the left the operator and a specific value on the right of the operator. The operator is '='.
HavingValue(string left, SqlBinaryOperator sqlOperator, object value)	ISqlHavingAndOr	Creates a `HAVING` clause, and adds a search condition to the `HAVING` clause. You can specify the SQL expression on the left the operator and a specific value on the right of the operator.