GROUP BY ID Attribute

This property determines how to group by a selected ID column when an expression is performed on the ID expression. Each of the options is described below. The code fragment following each description replaces the section named group by ID in the following sample SQL statement.

select a22.STORE_NBR STORE_NBR,

a22.MARKET_NBR * 10 MARKET_ID,

sum(a21.REG_SLS_DLR) WJXBFS1

from STORE_DIVISION a21

join LOOKUP_STORE a22

on (a21.STORE_NBR = a22.STORE_NBR)

where a22.STORE_NBR = 1

group by a22.STORE_NBR, group by ID

The options for this property are

Group by expression: Group by the expression performed in the Select statement on the ID column.
a22.MARKET_NBR * 10
Group by alias: Group by the expression alias in the Select statement.
MARKET_ID
Group by column: Group by the column ID, ignoring the expression performed on the ID column.
a22.MARKET_NBR
Group by position: Group by the physical table position of the ID column.
Use default inherited value
GROUP BY ID Attribute is an advanced property that is hidden by default.