[EMAIL PROTECTED] wrote on 01/13/2006 10:16:44 AM:
> I have a large table of filenames and creation dates from which I want
> to produce a histogram.
>
> SELECT year(date), quarter(date), count(0) FROM pics
> WHERE date(date) > '2000' AND date(date) < ' 2005'
> GROUP BY year(date), quarter(da
Mike Martin wrote:
I have a large table of filenames and creation dates from which I want
to produce a histogram.
SELECT year(date), quarter(date), count(0) FROM pics
WHERE date(date) > '2000' AND date(date) < ' 2005'
GROUP BY year(date), quarter(date)
Gets me close, but to simplify plottin
Hi,
2006/1/13, Mike Martin <[EMAIL PROTECTED]>:
> I have a large table of filenames and creation dates from which I want
> to produce a histogram.
>
> SELECT year(date), quarter(date), count(0) FROM pics
> WHERE date(date) > '2000' AND date(date) < ' 2005'
> GROUP BY year(date), quarter(date)
Mike,
I have a large table of filenames and creation dates from which I want
to produce a histogram.
SELECT year(date), quarter(date), count(0) FROM pics
WHERE date(date) > '2000' AND date(date) < ' 2005'
GROUP BY year(date), quarter(date)
Gets me close, but to simplify plotting, I want
I would typically do this in code, but you could also create a stored
procedure that does something like:
- create a temporary table
- populate it with all possible values with a count field set to 0
- run an REPLACE INTO temp_table
- dump the contents of the temp table
You may also want to just
I have a large table of filenames and creation dates from which I want
to produce a histogram.
SELECT year(date), quarter(date), count(0) FROM pics
WHERE date(date) > '2000' AND date(date) < ' 2005'
GROUP BY year(date), quarter(date)
Gets me close, but to simplify plotting, I want to include
