mysql -- 统计分组记录数

# 查询分组数 
SELECT count(*) from
(
SELECT count(*) as countnum
from u_userinfo
WHERE LENGTH(invitememberid) > 0
GROUP BY memberid
) t

posted @ 2016-07-29 16:11  蔡昊  阅读(796)  评论(0编辑  收藏  举报