110,538
社区成员
发帖
与我相关
我的任务
分享
SELECT VO.ID,V.VOTEID,VV.TITLE,VV.TYPE,VO.OP,COUNT(V.OPENID)AS 人数 from VoteResult AS V
LEFT JOIN VoteOption AS VO ON VO.ID=V.OPTIONID
LEFT JOIN Vote AS VV ON VV.Id=VO.VOTEID
WHERE V.VOTEID='66666'
GROUP BY VO.OP,VV.TITLE,V.VOTEID,VO.ID,VV.TYPE
SELECT VO.ID,V.VOTEID,VV.TITLE,VV.TYPE,VO.OP,COUNT(V.OPENID) AS 人数
from VoteOption AS VO
INNER JOIN VoteResult AS V ON VO.ID=V.OPTIONID
INNER JOIN Vote AS VV ON VV.Id=VO.VOTEID
WHERE V.VOTEID='66666'
GROUP BY VO.OP,VV.TITLE,V.VOTEID,VO.ID,VV.TYPE
select sum(0) as num,type from table group by type
至于你这个图,简单的连js插件都不要,直接就两个样式就可以