在所有版本的MysqL中,只需在SELECT列表中为聚合设置别名,并按别名排序:
SELECT COUNT(id) AS theCount, `Tag` from `images-tags`
GROUP BY `Tag`
ORDER BY theCount DESC
LIMIT 20
SQL分组依据和排序依据
在所有版本的MysqL中,只需在SELECT列表中为聚合设置别名,并按别名排序:
SELECT COUNT(id) AS theCount, `Tag` from `images-tags`
GROUP BY `Tag`
ORDER BY theCount DESC
LIMIT 20