SQLÓï¾äµÄÎÊÌâ

select  TOP (100) PERCENT dbo.vitem.Iid, COUNT(dbo.vote_c.Iid) AS num


cast(100*(case COUNT(dbo.vote_c.Iid) when 'a' then 1 else 0 end)/COUNT(dbo.vitem.Vid) as p)+'%' as percentage

from        dbo.vitem INNER JOIN
                      dbo.vote_c ON dbo.vitem.Iid = dbo.vote_c.Iid
WHERE    (dbo.vitem.flag = 0) AND (dbo.vote_c.flag = 0)
GROUP BY dbo.vitem.Iid, dbo.vitem.Itemtext, dbo.vitem.Vid


--Iid  ÊÇͶƱÈ˵ÄId £¬vidÊÇͶƱµÄ±àºÅ


ÎÒÏëÒªµÄÊÇͶƱÈË/ͶƱ×ÜÊý  ÏÔʾ°Ù·Ö±È  ±¨´íÊÇ  cast¸½½üÓÐÓï·¨´íÎó  Ï£Íû¸÷λ°ïæ¿´¿´£¬Ð»Ð»

---

ÊDz»ÊÇselect  TOP (100) PERCENT dbo.vitem.Iid, COUNT(dbo.vote_c.Iid) AS num ,¶ººÅÍü¼ÓÁË?

---

àÅ µ«ÊÇ »»ÁËÖ®ºó Óï¾äû´íÁË µ«ÊÇ  È«²¿³É100%ÁË...

---

select  TOP (100) PERCENT dbo.vitem.Iid, COUNT(dbo.vote_c.Iid) AS num,

cast(cast(COUNT(dbo.vote_c.Iid)*1.0*100/COUNT(dbo.vitem.Vid) as decimal(10,2)) as varchar(50)) +'%'


from        dbo.vitem INNER JOIN
                      dbo.vote_c ON dbo.vitem.Iid = dbo.vote_c.Iid
WHERE    (dbo.vitem.flag = 0) AND (dbo.vote_c.flag = 0)
GROUP BY dbo.vitem.Iid, dbo.vitem.Itemtext, dbo.vitem.Vid
{{----}