SQL Codes › SQL Return Codes -1 through -999 › -75 - CANNOT USE COLUMN FUNCTIONS WITH NO GROUP BY CLAUSE

-75 - CANNOT USE COLUMN FUNCTIONS WITH NO GROUP BY CLAUSE

Reason:

When no GROUP BY clause is present, you must either select only simple columns or use a column function on every column you select.

The SQLSTATE that equates to this SQL return code is 42S13.

Action:

Either remove the column function from the SELECT list or add the simple column to the GROUP BY clause.