62,041
社区成员
发帖
与我相关
我的任务
分享
select count(1) as ipsum, i.ip from ip as i INNER JOIN addIp as a ON i.ip = a.ip where username='dh002' and data='2011-5-31' group by i.ip with rollup
select count(1) as ipsum, i.ip,a.wbName from ip as i INNER JOIN addIp as a ON i.ip = a.ip where username='dh002' and data='2011-5-31' group by i.ip,a.wbName with rollup