[cmm324]

Hi, sorry for the delay in responding and I completely understand your position re:workbench.

The values from the query you provided could be useful but I was looking for something simpler like this:

 

SELECT

DISTINCT columnname as distinct_values,

COUNT(*) as occurrences

FROM tablename

GROUP BY distinct_values;

I find myself doing this often when working with table structures that make use of codes or integers for relation tables, like an id or code for a status column.

[Author]

Posts