Please check out the sample input and the expected output. SELECT `column`, COUNT(`column`) AS `value_occurrence` FROM `my_table` GROUP BY `column` ORDER BY `value_occurrence` DESC. Unfortunately I have only two columns … The total amount 10 is written as second column per every row. For example, if we had a table that looked like. Wondering how to extract the number of occurrence in a multiple value column. How to count the number of occurrences of a specific value in a column with a single MySQL query? Answer: The easiest way to resolve this task is mentioned below. Posted in.