select query to give sum and distinct values

Using mysql 3.23.51 I have a mysql table that holds records for telephone traffic. The table fields are as follows: idstartstop clidditot_dur day_dureve_durwkd_dur 1

Re: select query to give sum and distinct values

I didn't test it but you may try something like: SELECT ddi, sum(tot_dur) FROM table GROUP BY ddi ORDER BY ddi On Mon, 2003-01-20 at 12:59, Steve Mansfield wrote: Using mysql 3.23.51 I have a mysql table that holds records for telephone traffic. The table fields are as follows: id