Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Aggregating data

user572405Nov 18 2010 — edited Nov 19 2010
I have a table like this :
 Day, Qty
 10, 1
 11, 1
 12, 1
 13, 1
 14, 1
 
The output that I need to create is a summary data like:
 Day_List, Qty
  10,       1
  11,       1
  12,       1
  13,       1
  14,       1
  10_11,    2
  11_12,    2
  12_13,    2
  13_14,    2
  10_11_12, 3
  11_12_13, 3
  12_13_14, 3
 
The aggregate data will comprise for any 2 or 3 consecutive days. Thank you,

Kumar
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2010
Added on Nov 18 2010
4 comments
403 views