Sometimes when we are searching for something, we tend to look too deep and with wrong keywords. Forget about SQL procedures, the REPEAT() function and setting variables. If you want a result set with two columns, one the ID, and the other a frequency count, then use this: SELECT id, COUNT( someValue ) AS frequency FROM tableName GROUP BY someValue; Your welcome!
An attempt to seek clarity as I go through life writing code.