AnsweredAssumed Answered

ExecuteSQL and Count

Question asked by MikeWile on Dec 7, 2017
Latest reply on Dec 8, 2017 by beverly

If I have a table COLOR with field "Name". What is the easiest way to calculate the count of each similar name? I tried using a self-join table with no luck. I thought maybe ExecuteSQL might be a better choice but I have little knowlege of SQL and my luck at SELECT Count was not good.

 

Screen Shot 2017-12-07 at 6.35.23 AM.png

Outcomes