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


MySqlSelectStatement stmt = new MySqlSelectStatement(); 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 MySqlCommand command = new MySqlCommand(stmt.ToString());

MySqlSelectStatement stmt = new MySqlSelectStatement();
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
MySqlCommand command = new MySqlCommand(stmt.ToString());

Visual Basic


Dim stmt As New MySqlSelectStatement 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 MySqlCommand(stmt.ToString)

Dim stmt As New MySqlSelectStatement
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 MySqlCommand(stmt.ToString)

Reference

SelectStatement Class
SelectStatement Members

Send Feedback