按计数从列顺序中选择唯一值 [英] select unique values from a column order by count

问题描述

我使用此代码:

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

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

But how can I ORDER it via count of values?

像这样:

$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;

这篇关于按计数从列顺序中选择唯一值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！