简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
MYSQL 双表联查 + 统计 + 排序
PHP中文网
PHP中文网 2017-04-17 12:06:09
0
2
219
PHP中文网
PHP中文网

认证高级PHP讲师

reply all(2)
大家讲道理
大家讲道理2017-04-17 12:08:09 2 floor

这样可以?
SELECT name,count(userid) FROM vote v,user u where u.id = v.userid group by userid;

Like +0
Add Reply
刘奇
刘奇2017-04-17 12:08:09 1 floor

Whether it can be achieved depends on your SQL level

Like +0
Add Reply
Popular Topics
More>
Popular Articles
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！