Having Property

In This Topic

Gets or sets HAVING clause of the statement.

Syntax

Visual Basic
C#

'Declaration
 
Public Overridable Property Having As String

public virtual string Having {get; set;}

Property Value

The HAVING clause of the statement.

Remarks

To quickly add new condition to the clause use the AddHavingCondition method.

Example

The following example demonstrates how to use the Having property.

csharp

UniSelectStatement stmt = new UniSelectStatement();
SelectColumn jobName = new SelectColumn("JOB");
stmt.Columns.Add(jobName);
stmt.Columns.Add(new SelectColumn("AVG(SAL)"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.GroupBy.Add(jobName);
stmt.Having = "AVG(SAL) > 1000";

//select JOB,AVG(SAL) from emp group by JOB having AVG(SAL) > 1000
UniCommand command = new UniCommand(stmt.ToString());

Visual Basic

Dim stmt As New UniSelectStatement
Dim jobName As New SelectColumn("JOB")
stmt.Columns.Add(jobName)
stmt.Columns.Add(New SelectColumn("AVG(SAL)"))
stmt.Tables.Add(New SelectTable("emp"))

stmt.GroupBy.Add(jobName)
stmt.Having = "AVG(SAL) > 1000"

'select JOB,AVG(SAL) from emp group by JOB having AVG(SAL) > 1000
Dim command As New UniCommand(stmt.ToString)

Reference

SelectStatement Class
SelectStatement Members

Send Feedback