Re: [SQL] columns for count histograms of values

2008-04-30 Thread chester c young
--- 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

Re: [SQL] columns for count histograms of values

2008-04-30 Thread Mag Gam
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

[SQL] columns for count histograms of values

2008-04-30 Thread 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 -

Re: [SQL] Curious about wide tables.

2008-04-30 Thread Jean-David Beyer
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