MySQL查询是什么来计算包含相同值的总行数。例如:
考虑一个包含所有动物名称的表animal
。如果表中有5行包含值name
作为'cow'
,那么它的查询是什么?
SELECT animal_name,
COUNT(*) AS animal_count
FROM animal_table
GROUP BY animal_name;
SELECT COUNT(*) AS CowCount
FROM tableName
where animalName = 'cow';
SELECT name, COUNT(*) c FROM animal WHERE name='cow' GROUP BY name