php - 如何按频繁值对 "GROUP BY"查询结果进行排序？

Question

我编写了 php 应用程序，它获取用户浏览器的名称:

+----------+------------+
| name     | browser    |
+----------+------------+
| Puffball | firefox    |
| Chirpy   | edge       |
| Whistler | chrome     |
| Slim     | firefox    |
| Claws    | edge       |
| Fluffy   | chrome     |
| Fang     | chrome     |
| Bowser   | safari     |
| Buffy    | chrome     |
+----------+------------+

我使用这个sql查询来获取带有“GROUP BY”的浏览器，结果是:

$sql = "SELECT * FROM views WHERE linkid = '$string' GROUP BY browser";

array (size=4)
  0 => string 'firefox'
  1 => string 'edge'
  2 => string 'chrome'
  3 => string 'safari'

我想按频繁值对此结果进行排序，如下所示:

array (size=4)
  0 => string 'chrome'
  1 => string 'edge'
  2 => string 'firefox'
  3 => string 'safari'

坦克斯!

Answer 1

为了获得按输入表中提到的浏览器频率排序的结果，您需要添加这样的计数，然后按计数列排序

SELECT *, count(browser) as frequency
FROM views 
WHERE linkid = '$string' 
GROUP BY browser
ORDER by frequency