3,491
社区成员
发帖
与我相关
我的任务
分享
select /*+ ordered use_nl(B,A) */
to_char(A.record_time,'yyyy-mm-dd hh24:mi:ss'),
SUM(A.TCP4_BYTE_IN),
SUM(A.TCP4_BYTE_OUT) ,
SUM(A.TCP4_PKTNUM_IN),
SUM(A.TCP4_PKTNUM_OUT)
from protocol B,applicationdata A
where A.APPLICATION_PROTOCOL = B.PROTOCOL_ID
and A.link_id = 342
and A.group_id = 1
group by A.record_time
order by A.record_time