SUM minutes SQL server

Posted by sandu on Stack Overflow See other posts from Stack Overflow or by sandu
Published on 2010-04-12T10:00:08Z Indexed on 2010/04/12 10:03 UTC
Read the original article Hit count: 96

Filed under:
|
|
|
|

HI guys, My litle problem goes like this : I have this columns : PHONE_NR , TIME ( time field ), Meaning the calling telephone number and call duration. I need to group phone nr and sum the minutes. Filds looks like this :

 nr          time 
726028xxx 00:07:07 
735560css 00:07:37 
726028xxx 00:07:55 

© Stack Overflow or respective owner

Related posts about sql

Related posts about server