SQL Codes › SQL Return Codes -1 through -999 › -103 - MUST USE COLUMN FUNCTIONS IF HAVING CLAUSE WITH NO GROUP BY

-103 - MUST USE COLUMN FUNCTIONS IF HAVING CLAUSE WITH NO GROUP BY

Reason:

The query in question contains a HAVING clause but it does not contain a GROUP BY clause, and either it is a SELECT * or all selected columns are not inside column functions.

The SQLSTATE that equates to this SQL return code is 42803.

Action:

Add a GROUP BY clause or change the SELECT list to include only column functions.