Re: Analytical funtion

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 16 Jun 2006 19:01:12 +0200
Message-ID: <4492e3d7$0$20856$626a54ce@news.free.fr>

"hardnut" <tenorense_at_yahoo.com> a écrit dans le message de news: 1150475425.346708.53610_at_f6g2000cwb.googlegroups.com...
| Hi All,
| Please help with this query.
| I am trying to calculate the cummulative inventory by subtracting
| sales from receipt. If the inventory is nagative, I want to make it
| zero and start again from the next reciept value. Otherwise, I add the
| previous inventory value to the current receipt and subtract the
| current sales.
|
| Your help will be invaluable.
|
| Thanks.
|

What's your Oracle version?

Regards
Michel Cadot Received on Fri Jun 16 2006 - 12:01:12 CDT