InterSystems IRIS TSQL Code 147 An aggregate may not appear in the WHERE

AbundantCode 1 week ago in InterSystems IRIS 0

In this post, you’ll learn about the SQL error code 147 in InterSystems IRIS database the reason why you are receiving the TSQL message when using the InterSystems IRIS data platform

Error Code :

147

Reason for the Error code 147 in InterSystems IRIS DBMS

An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

Tags :

Leave Your Comment