select sum(*) from student where name='张三' or name='李四'
那就是select count(*) from student where name='张三' or name='李四'
--分别统计?那就这样 select 张三记录数=sum(case when name='张三' then 1 else 0 end), 李四记录数=sum(case when name='李四' then 1 else 0 end) from student where name='张三' or name='李四'
select name, count(*) from student where name in ('张三','李四') group by name
select 张三记录数=sum(case when name='张三' then 1 else 0 end),
李四记录数=sum(case when name='李四' then 1 else 0 end)
from student where name='张三' or name='李四'