Answer the question
In order to leave comments, you need to log in
How to find "missing" rows in MySQL?
There is a mysql table:
`id` = 1, `model` = 1, `language` = 1
`id` = 2, `model` = 1, `language` = 2
`id` = 3, `model` = 1, `language` = 3
`id` = 4, `model` = 2, `language` = 1
... The
maximum value of `language` is 34.
I need to find all `model` that do not have all `language` values. Those. those `model` for which there are not all 34 `language`.
Answer the question
In order to leave comments, you need to log in
SELECT `model`, count(`language`) AS `c` FROM `table` GROUP BY `model` HAVING `c` < 34;
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question