--- Alexy Khrabrov <[EMAIL PROTECTED]> wrote:
> Greetings -- I have a table of the kind
>
> Ratings:
> id integer
> rating smallint
>
> -- where value can take any value in the range 1 to 5. Now I want to
>
> have a statistical table Stats of the form
>
> id integer
> min smallint
> max sma
Just curious, how are you planning to display the histogram?
Are you allowed to use application code (C/C++/Perl, etc..) to generate the
histogram? Personally, SQL is great for showing the data but not good for
making graphs with data you can show.
On Wed, Apr 30, 2008 at 5:01 PM, Alexy Khrabrov
Greetings -- I have a table of the kind
Ratings:
id integer
rating smallint
-- where value can take any value in the range 1 to 5. Now I want to
have a statistical table Stats of the form
id integer
min smallint
max smallint
avg real
r1 integer
r2 integer
r3 integer
r4 integer
r5 integer
-
Shane Ambler wrote:
> Jean-David Beyer wrote:
>> In another thread, the O.P. had a question about a large table with
>> over 100 columns. Is this usual? Whenever I make a database, which is
>> not often, it ends up with tables that rarely have over to columns, and
>> usually less than that. When n