本文介绍了按每个值的 COUNT 排序的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有一张表格，其中存储了 ID 和商店所在的城市.
I have a table which stores IDs and the city where the store is located.
我想列出所有商店，从商店最多的城市中的商店开始.
I want to list all the stores starting with the stores that are in the city where there are the most stores.
表格
ID CITY
1 NYC
2 BOS
3 BOS
4 NYC
5 NYC
我想要的输出如下，因为我在纽约市拥有最多的商店，我希望首先列出纽约市的所有位置.
The output I want is the following since I have the most stores in NYC, I want all the NYC location to be listed first.
1 NYC
4 NYC
5 NYC
2 BOS
3 BOS
推荐答案
SELECT count(City), City
FROM table
GROUP BY City
ORDER BY count(City);
或
SELECT count(City) as count, City
FROM table
GROUP BY City
ORDER BY count;
啊，抱歉，我误解了你的问题.我相信 Peter Langs 的回答是正确的.
Ahh, sorry, I was misinterpreting your question. I believe Peter Langs answer was the correct one.
这篇关于按每个值的 COUNT 排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！