从列中按计数顺序选择唯一值


select unique values from a column order by count

我使用以下代码:

$sql = "SELECT DISTINCT(name) AS name FROM Tags  ORDER BY name DESC"

但是我如何通过值计数来订购它?

像这样:

$sql = "SELECT DISTINCT(name) AS name FROM Tags  ORDER BY count(name) DESC"

SQL 小提琴

SELECT count(name) as count, name
FROM Tags
GROUP BY name
ORDER BY count DESC;