Home Forums Article Discussions Article Discussions by Author Discuss content posted by Dave M Distinct clause in Select statement RE: Distinct clause in Select statement

  • August 2, 2010 at 7:04 am

    #1200978

    Explanation: The distinct clause guarantees all output records will be unique, irrespective of how you write the select statement.

    CREATE TABLE TABLE2(

    Col1 int

    ,Col2 int)

    INSERT INTO table2 VALUES(1,3)

    INSERT INTO table2 VALUES(1,4)

    SELECT DISTINCT Col1,Col2 FROM table2

    I agree the use of parenthesis wont affect the output.

    But while using 2 columns with DISTINCT can produce non unique rows (ateleast in one columm...:-))

    John