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
    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.
    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
    Requirements

    Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

    See Also