group by and SQL standards

The SQL standards for group by are more restrictive than the Sybase standard.The SQL standard requires that:

set fipsflagger on

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

Several Transact-SQL extensions (described in the following sections) relax these restrictions. However, the more 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: