Re: [GENERAL] multiple rows by date using count(*)

2009-07-05 Thread Alban Hertroys
On Jul 5, 2009, at 5:20 AM, Shad Keene wrote: PRB | RBL | SAC | SFO | June 1 2 | 4 | 5| 2| June 2 1 | 3 | 4| 0| June 3 0 | 2 | 1| 2| So far, here's the query I'm using to display one row of all items with certain keywords, b

Re: [GENERAL] multiple rows by date using count(*)

2009-07-05 Thread Andreas Kretschmer
Shad Keene wrote: > Hi, > I have data that I'd like to organize spatially by date. So far, I'm only > succeeding in displaying the number of times something occurs out of the whole > dataset. > > Here's an example of what I want to do. > 343 items that occurred at different times from june thro

[GENERAL] multiple rows by date using count(*)

2009-07-04 Thread Shad Keene
Hi, I have data that I'd like to organize spatially by date. So far, I'm only succeeding in displaying the number of times something occurs out of the whole dataset. Here's an example of what I want to do. 343 items that occurred at different times from june through july. multiple different ke