[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) < ' 20
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
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) < ' 2
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
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 rows for
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 p
George Eric R Contr AFSPC/CVYZ writes:
> Is there any function/command/neat query that you can use to get a histogram
> of a column's values? I didn't find anything in the manual or the DuBois
> book.
GROUP BY does the trick, as long as you can make an expression
that conv
Is there any function/command/neat query that you can use to get a histogram
of a column's values? I didn't find anything in the manual or the DuBois
book.
If not, can anybody comment on how difficult this might be to implement as a
user defined function? I haven't looked into t
