var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: please help....
does anyone know how to make a frequency diagram with groups
in Oracle? I have data like
my query for the data above is:
SELECT COUNT(*) frequency,size
GROUP BY size
I would have data like
Last edited by miggul; 11-11-03 at 09:42.
Re: please help....
Something like this:
SELECT TO_CHAR(TRUNC(size,-2))||'-'||TO_CHAR(TRUNC(size,-2)+100) size, SUM(frequency)
GROUP BY TRUNC(size,-2);