dotConnect for DB2 Documentation
Devart.Common Namespace / SelectStatement Class / Distinct Property
Example

In This Topic
Distinct Property
In This Topic
Gets or sets whether statement should request unique rows only.
Syntax
'Declaration
 
Public Property Distinct As Boolean
 

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.
DB2SelectStatement stmt = new DB2SelectStatement();
stmt.Columns.Add(new SelectColumn("JOB"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.Distinct = true;

//select distinct JOB from emp
string queryText = stmt.ToString();
Dim stmt As New DB2SelectStatement
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
See Also