qxandxt

导航

mysql 查询分组后的总条数

select count(*) from (select distinct startperson_id,count(startperson_id) as num from apphome_finance group by startperson_id having num>10 and startperson_id=2)subQuery;

posted on 2020-10-14 17:32  qxandxt  阅读(506)  评论(0编辑  收藏  举报