group by question

fanfan1980

When specifying GROUP BY, all columns in any non-aggregate expression in the select list should be included in the GROUP BY list, or the GROUP BY expression must exactly match the select list expression.