Home Forums Testing Center Question of the Day (QOD) Question of the Day for 30 Nov 2005 RE: Question of the Day for 30 Nov 2005
emiddlebrooks
Hall of Fame
Points: 3365
More actions
November 30, 2005 at 8:02 am
#606746
Even though I got it correct I don't think it is completely correct.
select col1, col2, "extra" = 'X' from table1 group by col1, col2
would work even though the column "extra" is a non-aggregate and is not in the group by.