按每个值的 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.
相关文章