InterSystems IRIS TSQL Code 8177 Cannot use a column in the %hs clause un

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

Error Code :

8177

Reason for the Error code 8177 in InterSystems IRIS DBMS

Cannot use a column in the %hs clause unless it is contained in either an aggregate function or the GROUP BY clause.