Home Forums RE: Question of the Day for 30 Nov 2005

  • I got this correct, but only because i had to assume that the "correct" answer wouldnt be totally correct.

    Select 1 as "Col1", Col2, Col3

    From Table

    Group By Col2, Col3

    ...will work, and I would consider 1 a non-aggregate, or is that an incorrect statement.