One way would be to use a nested query: SELECT count(*) FROM ( SELECT COUNT(Genre) AS count FROM movies GROUP BY ID HAVING (count = 4) ) AS ...
確定! 回上一頁