SELECT COUNT(1) AS 某个字段去重后的条数,SUM(num) AS 总条数 FROM (SELECT COUNT(1) AS num FROM 表名 GROUP BY 字段名) T;
mysql查询某个字段去重之后的条数和总条数
最新推荐文章于 2024-04-17 15:25:46 发布
SELECT COUNT(1) AS 某个字段去重后的条数,SUM(num) AS 总条数 FROM (SELECT COUNT(1) AS num FROM 表名 GROUP BY 字段名) T;