group by and SQL Standards

The SQL standards for group by are more restrictive than the default SAP ASE standard.

The SQL standard requires that:
Several Transact-SQL extensions (described in the following sections) relax these restrictions. However, complex result sets may be more difficult to understand. If you set the fipsflagger option as follows, you will receive a warning message stating that Transact-SQL extensions are used:
set fipsflagger on

For more information about the fipsflagger option, see the set command in the Reference Manual: Commands.