Code :
SELECT to_char(stamp_inserted, 'MI') minutes, sum(decode(mac_src, 'taval', packets, 0)) packets_inpout, sum(decode(mac_src, 'taval', bytes, 0)) bytes_outpout, sum(decode(mac_dts, 'taval', packets, 0)) packets_outpout, sum(decode(mac_dts, 'taval', bytes, 0)) bytes_outpout FROM trucmuch WHERE mac_src = 'taval' OR mac_dst = 'taval' AND to_number(to_char(stamp_inserted, 'H24')) = heuredésirée GROUP BY to_char(stamp_inserted, 'MI')
|