sql语句,两次分组查询
SELECT `siteid` , `date` , count( DISTINCT ip )
FROM rawlogodd
WHERE `date` >= '2005-3-1'
AND date <= '2005-3-31'
GROUP BY `siteid` , `date`
得到的结果是这样的
siteid date count( DISTINCT ip )
0 2005-03-01 1
0 2005-03-02 1
0 2005-03-03 1
0 2005-03-04 1
3 2005-03-01 434
3 2005-03-02 466
3 2005-03-03 378
怎样再统计各个siteid 在三月份里的总数。