SELECT ID具有ID的最大数量

SELECt color_id AS id, COUNT(color_id) AS count
FROM products
WHERe item_id = 1234 AND color_id IS NOT NULL
GROUP BY color_id
ORDER BY count DESC
LIMIT 1;

这将为您提供color_id以及该color_id上的计数，该计数按从最大到最小的顺序排列。我想这就是你想要的。

供您编辑…

SELECt color_id, COUNT(*) FROM products WHERe color_id = 3;