Let me admit I am not good at SQL and I need help. I want the sum of connections with in min and group my time order by time

connections Time
36556 09:13:00
36812 09:13:00
37310 09:13:00
37746 09:13:00
38547 09:13:00
38906 09:13:01


I would like ot get it inthis format using SQL


Totconnections Time

225877 09:13

db2 "select sum(connections)as Totconnections , ifs_server_tm as Time from ANDT.SESTATS01 where IFS_SERVER_dt = CURRENT DATE group by IFS_SERVER_TM order by IFS_SERVER_TM "

I am getting data

186971 09:13:00
38906 09:13:01

something like this
(0)[db2inst1@dlx00031 thebrain]$ db2 "select sum(connections),substr(char(ctime),1,5) from tt group by substr(char(ctime),1,5) order by 2"

1 2
----------- -----
600 09:13

1 record(s) selected.

(0)[db2inst1@dlx00031 thebrain]$ db2 "select * from tt"

CONNECTIONS CTIME
----------- --------
100 09:13:00
200 09:13:01
300 09:13:02

3 record(s) selected.

thank you so much przytula for your help.

It worked great.