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

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

Visual Basic

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

Reference

SelectStatement Class
SelectStatement Members

Send Feedback