Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Histogram/Bucketizing resultset
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