running total (SQL query)
From: Bruno Cirone <bruno_at_bc3.GUN.de>
Date: Tue, 12 Jan 1993 18:39:53 GMT
Message-ID: <C0r7uI.po_at_bc3.GUN.de>
Date: Tue, 12 Jan 1993 18:39:53 GMT
Message-ID: <C0r7uI.po_at_bc3.GUN.de>
I have this table:
Name Score
Werner 200 Hugo -100 Heinz 300 Bruno 100
I want this table to be printed like the following:
Name Score total
Werner 200 200 Hugo -100 100 Heinz 300 400 Bruno 100 500
How can I do that with Oracle (without report-generator) ?
-- Bruno Cirone InterNet: <bruno_at_bc3.gun.de> Theodor-Heuss-Ring 19-21 UUCP: ...!unido!easix!flyer!bc3!bruno 5000 Koeln (Cologne) 1 Fax : +49-221-7710931 FRG / Germany Tel.: +49-221-7710929Received on Tue Jan 12 1993 - 19:39:53 CET