I think the result of the need to Picture 2 cross-cutting sum select shipper.trans_no, shipper_line.part_id as customer_id, shipper_line.quantity, shipper.trans_date, shipper_line.unit_price, shipper_line.line_no, shipper_line.all_amt, sum(shipper_line.all_amt) over (partition by shipper_line.part_id order by shipper.trans_date rows between unbounded preceding and current row) as shipper_allamt from shipper join shipper_line on (shipper.trans_no=shipper_line.trans_no) where shipper.trans_date between '2013-10-01' and '2013-10-30' |
What is your question?