RE: sum queries

2004-12-03 Thread James Nunnerley
> -Original Message- > From: James Nunnerley [mailto:[EMAIL PROTECTED] > Sent: 03 December 2004 16:13 > To: 'Roger Baklund'; '[EMAIL PROTECTED]' > Subject: RE: sum queries > > > -Original Message- > > From: Roger Baklund [mailto:

RE: sum queries

2004-12-03 Thread James Nunnerley
> -Original Message- > From: Roger Baklund [mailto:[EMAIL PROTECTED] > Sent: 03 December 2004 16:03 > To: [EMAIL PROTECTED] > Cc: James Nunnerley > Subject: Re: sum queries > > James Nunnerley wrote: > > I'm trying to create a table, and ultimately a

sum queries

2004-12-03 Thread James Nunnerley
I'm trying to create a table, and ultimately a graph, out of some syslog data. I have a table with the following info in it: Time (unixtime stamp), bytes rcvd and bytes sent I want to create a sql statement that group the data over a certain period of time, and produces the following table