Binning data

From: James Petts <jpetts_at_celltech.co.uk>
Date: Mon, 26 Apr 1999 15:21:16 GMT
Message-ID: <37248393.23839198@right.celltech>

I have a series of real numbers, and I want to bin the data by ranges, and get a count of the number of values in each bin. The values range from 75.1 to 1200.4, and I want to bin them in steps of fifty. Thus, I want to count all values between 50.0001 and 100.0000, between 100.0001 and 150.0000, etc., all the way up to the range from 1200.0001 to 1250.0000.

Can anybody suggest an easy way to do this in SQL or do I need to resort to PL/SQL?

James Petts Received on Mon Apr 26 1999 - 10:21:16 CDT