By default, Information Object Designer creates a GROUP BY clause automatically. If you prefer, you can create a GROUP BY clause manually.
When an information object’s SELECT clause includes an aggregate column and one or more non-aggregate columns, the non-aggregate columns must appear in the GROUP BY clause. If the non-aggregate columns do not appear in the GROUP BY clause, Information Object Designer displays an error message. For example, consider the following information object:
If automatic grouping does not generate the desired SQL query, create the GROUP BY clause manually. Create the GROUP BY clause manually if you want to group on a column that does not appear in the SELECT clause, for example: