mysql - 如何从过滤后的 MYSQL 查询中获取计数

Question

我做了如下sql查询:

SELECT ip ,count(*) AS count FROM Abfragen WHERE sid = 1 GROUP BY ip ORDER BY count DESC limit 10

结果是:

ip             count

52.28.9.253     35046

213.128.143.1   3860

5.10.190.222    106

52.58.240.24    58

52.58.99.201    42

81.184.0.178    30

217.159.201.54  6

但我还想要结果的总记录数，例如这里 7。

谁能告诉我如何获得它吗？谢谢。

Answer 1

你可以简单地这样做

更新:

Select Count(*) 
From (Select `ip`,count(*) as count 
    FROM (`Abfragen` 
    where `sid` = 1 
    Group BY `ip` 
    ORDER BY count DESC limit 10) AS IP_COUNT