MySQL:计数条目而不进行分组? [英] MySQL: Count entries without grouping?

问题描述

我想提取结果并计算每个名称中有多少被提取但没有分组...

I want to pull results and count how many of each name is pulled but without grouping...

例如，我想要这个:

John Doe 3
John Doe 3
John Doe 3
Mary Jane 2
Mary Jane 2

代替此:

John Doe 3
Mary Jane 2

这有意义吗?

谢谢.

推荐答案

SELECT b.name, a.the_count
FROM
  some_table b, 
  (SELECT name, COUNT(*) AS the_count
  FROM some_table
  GROUP BY name) AS a
WHERE b.name = a.name

这篇关于MySQL:计数条目而不进行分组?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！