2009年
-
编辑 删除
分组统计
单个表的分组统计（计数、求和）select sendid,recvid,type,count(sendid) as counts ,sum(size) as sizesfrom yictstatwhere sendid in ('','') or recvid in ('','')group by sendid,recvid,type两个相同表结构的表union all分组统计（计数、求和）select u.sendid,u.recvid,u.type,count(u.sendid) as counts ,sum(u.size) as sizesfrom (select * from marinebillunion allselect * from yictbk) as uwhere u.sendid in ('','') or u.recvid in ('','')group by u.sendid,u.recvid,u.type两个相同表结构的表先合并到一个表再分组统计（
