SELECT b.Type , COUNT(*) AS 记录数 FROM IPTable AS a INNER JOIN IPMaster AS b ON a.IP BETWEEN b.StartIP AND b.EndIP GROUP BY b.Type;
select type, count(*) from t group by type
27,579
社区成员
68,558
社区内容
加载中
试试用AI创作助手写篇文章吧