天天看點

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;