您可以通过简单地运行以下查询来实现这一点

SELECT 
      Name as UniqueNames, count(Name) as occurrences
FROM
      tableName
HAVING occurrences > 0 --you may ignore this condition
GROUP BY Name
ORDER BY UniqueNames

你可以用 group by ```
SELECT Name , count(Name) as Appearance
FROM yourtable
GROUP BY NAME

您将需要使用distinct和group by来获得外观数，如下所示：

SELECT distinct(Name), count(Name) as 'Appearance' from test_table group by Name;

您可以在下面尝试使用聚合函数count（）并应用group by

SELECT 
   Name,count(Name) as UniqueNames
FROM
   tableName
group by Name

您可以使用：

SELECT 
   Name, count(Name) as TotalAppearance
FROM
   tableName
group by Name
having count(Name) > 0
order by TotalAppearance desc;

您也可以使用order by。