示例表資料：
id | name | tool
--------------------
1 | bob | scissor
2 | mike | knife
3 | john | thread
4 | joe | ruler
5 | kim | marker
6 | dean | board
7 | paul | knife
8 | john | scissor
9 | kim | ruler
10| mike | scissor
11| mike | board
12| joe | board
13| paul | scissor
13| jake | marker
并希望從“工具”列中獲得前 5 個最常見的資訊，這會告訴我類似
1 - scissor (4)
2 - board (3)
3 - knife (2)
4 - ruler (2)
5 - marker (2)
uj5u.com熱心網友回復：
您可以對工具進行計數，然后按數量限制為 5 進行排序。
select tool,count(tool) as nr_count
from test
group by tool
order by nr_count desc limit 5;
結果：
tool nr_count
scissor 4
board 3
knife 2
ruler 2
marker 2
https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=4c95c05c966d262547f752a2cb599b3b
請注意，您還有另一個工具，上面的查詢沒有考慮到 2 個結果。您需要通過以下方式申請另一個訂單
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/467578.html
標籤：mysql 选择 sql-order-by
下一篇：進行MySQLCOUNT查詢