Gets or sets HAVING clause of the statement.
public virtual string Having {get; set;}
'Declaration
Public Overridable Property Having As String
Property Value
The HAVING clause of the statement.
The following example demonstrates how to use the
Having property.
DB2SelectStatement stmt = new DB2SelectStatement();
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
DB2Command command = new DB2Command(stmt.ToString());
Dim stmt As New DB2SelectStatement
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 DB2Command(stmt.ToString)