Distinct Property

In This Topic

Gets or sets whether statement should request unique rows only.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Distinct As Boolean

public bool Distinct {get; set;}

Property Value

true, if the result set should contain unique rows only; otherwise, false.

Example

The following example demonstrates how to use the Distinct property.

csharp

SQLiteSelectStatement stmt = new SQLiteSelectStatement();
stmt.Columns.Add(new SelectColumn("JOB"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.Distinct = true;

//select distinct JOB from emp
string queryText = stmt.ToString();

Visual Basic

Dim stmt As New SQLiteSelectStatement
stmt.Columns.Add(New SelectColumn("JOB"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Distinct = True

'select distinct JOB from emp
Dim queryText As String = stmt.ToString

Reference

SelectStatement Class
SelectStatement Members

Send Feedback