Show / Hide Table of Contents

    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.
    Back to top Generated by Appeon