我有一句sql的语句是:
select count(spid)
from r_wtbs_homepage_h
where fetch_time = 2010060111 group by spid
结果得到了每一个分组后的spid的总数,共3条记录,每条记录就是相应分组后的spid的总数,但我其实就是想得到这个3,而不是每一条spid的总数,请问下这个sql应该怎样改啊?
select count(spid)
from r_wtbs_homepage_h
where fetch_time = 2010060111 group by spid
结果得到了每一个分组后的spid的总数,共3条记录,每条记录就是相应分组后的spid的总数,但我其实就是想得到这个3,而不是每一条spid的总数,请问下这个sql应该怎样改啊?
select spid ,count(spid)
from r_wtbs_homepage_h
where fetch_time = 2010060111 group by spid
(select count(spid)
from r_wtbs_homepage_h
where fetch_time = 2010060111 group by spid)外面再套个查询,得到你要的,,,