按每个值的 COUNT 排序

2021-11-20 00:00:00 sql count mysql sql-order-by

我有一张表格，其中存储了 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.

相关文章