Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Histogram/Bucketizing resultset

Histogram/Bucketizing resultset

From: NoSpamPlease <googleposer_at_yahoo.com>
Date: 30 Oct 2002 20:45:55 -0800
Message-ID: <499d4ffb.0210302045.452ef143@posting.google.com>


Given an input table T(age)

Age
27
24
34
56
40
76
30
32
67
71

I would like to generate the following output

Range		Value
0-10		0
11-20		0
21-30		2
31-40		4
41-50		0
51-60		1
61-70		1
71-80		2
81-90		0
91-100		0


Can anyone help me with a query
Thx in adv Received on Wed Oct 30 2002 - 22:45:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US