MySQL:不分组计算条目？

Question

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

例如，我想要这样：

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

而不是这样：

John Doe 3
Mary Jane 2

这有意义吗？

谢谢。

Answer 1

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

Answer 2

它使用group by，但以您想要的格式获得输出。

SELECT Name, NG.NameCount
FROM Names
INNER JOIN
    (SELECT Name, Count(1) As NameCount
    FROM Names
    GROUP BY Name) NG
ON Names.Name = NG.Name

Answer 3

SELECT  mo.*,
        (
        SELECT  COUNT(*)
        FROM    mytable mi
        WHERE   mi.name = mo.name
        )
FROM    mytable mo