Loading

How can I get some coulmn data by second

diamond diamond

Hi all,

I have a table with multiple coulmns such as time, source, destination, packets.

I want to get number of packets for every source in every second.

Please help me

Thanks in advance

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilanka Dharmadasa12y ago
SELECT SUM(packets), convert(varchar, time, 120), source FROM [table_name] group by convert(varchar, time, 120), source