+ -
当前位置:首页 → 问答吧 → mysql分组统计sql

mysql分组统计sql

时间:2011-06-29

来源:互联网

SELECT wb.sid, wb.nid, wb.uid
FROM `mama_webform_submissions` wb
LEFT JOIN shared_users user ON user.uid = wb.uid
WHERE user.created
BETWEEN 1298937600 
AND 1301616000 
ORDER BY user.uid ASC 


我想从shared_users统计每个用户参加多少调查问卷mama_webform_submissions
结果以
user.uid 参加的个数列出来,谢谢
例如:
uid 次数
1 20

作者: sjqzone   发布时间: 2011-06-29

贴记录及要求结果出来看

SELECT user.uid,count(*)
FROM shared_users user 
LEFT JOIN `mama_webform_submissions` wb ON user.uid = wb.uid
WHERE user.created
BETWEEN 1298937600  
AND 1301616000  
group by user.uid
ORDER BY user.uid ASC

作者: wwwwb   发布时间: 2011-06-29

相关阅读 更多