group data

[ridhirao22]

I have a table with order_number, order_date, qty, amount.
I need to group amount data in 50’s ( like 50,100,150,200..6000) and count the orders and sum qty for each bucket. I came across the width_bucket function but I don’t understand how I tell the bucket width. Is there any easy way of do this?

Please advice.

TIA,
RR

 

[Thargy]

I googled and found an example at

http://download.oracle.com/docs/cd/B28359_01/olap.111/b28126/dml_functions_2137.htm.

May I suggest that you create a table, populate it with some sample data and then try it out.

If you then have trouble, post the create table statement, insert statement and your query. That will make it much more likely that someone on the forum will be able to help.

Regards

T