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
|387 |
| 5 | 10 |225 |
|10 | 15 | 74 |
+---+--++
Thanks
Aveek
From: Ghulam Mustafa [mustafa...@gmail.com]
Sent: Tuesday, July 27, 2010 3:53 PM
To: mysql@lists.mysql.com
Subject: query results group/summed by
Hi everyone,
i have two columns (seconds, number of calls), i need to produce a
report which will show total number of calls in intervals (let'say 10
seconds interval), i know i can do this programmability in my script but
i was wondering if it's possible to accomplish this behavior within
mysql.
