Travis
> Date: Sun, 1 Aug 2010 13:16:36 +0100
> From: nuno.tava...@dri.pt
> To: mgai...@hotmail.com
> CC: cuong.m...@vienthongso.com; ave...@yahoo-inc.com; mustafa...@gmail.com;
> mysql@lists.mysql.com
> Subject: RE: query results group/s
by interval
> >
> > Hi Aveek,
> >
> > I think Ghulam just want to count calls for each intervals
> > so the query should looks like this:
> >
> > select count(*) as total_calls, queue_seconds
> > from calls group by queue_seconds order by total_cal
bilité
pour le contenu fourni.
> Date: Sat, 31 Jul 2010 10:31:43 +0700
> From: cuong.m...@vienthongso.com
> To: ave...@yahoo-inc.com
> CC: mustafa...@gmail.com; mysql@lists.mysql.com
> Subject: Re: query results group/summed by interval
>
> Hi Aveek,
>
> I think Ghulam j
bilité
pour le contenu fourni.
> Date: Sat, 31 Jul 2010 10:31:43 +0700
> From: cuong.m...@vienthongso.com
> To: ave...@yahoo-inc.com
> CC: mustafa...@gmail.com; mysql@lists.mysql.com
> Subject: Re: query results group/summed by interval
>
> Hi Aveek,
>
> I think Ghulam j
ustafa" , mysql@lists.mysql.com
Sent: Tuesday, July 27, 2010 5:54:13 PM
Subject: RE: query results group/summed by interval
try this ...
select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end,
sum(calls) from calls group by 5 * floor(seconds/5);
This should give you a
try this ...
select 5 * floor(seconds/5) as start, 5 * floor(seconds/5) + 5 as end,
sum(calls) from calls group by 5 * floor(seconds/5);
This should give you an output of the type
+---+--++
| start | end | sum(calls) |
+---+--++
| 0 |5 |
