Sql Help

From: <kishanthakker_at_gmail.com>
Date: 29 Jul 2005 04:46:15 -0700
Message-ID: <1122637575.925420.48280@f14g2000cwb.googlegroups.com>

I have a very specific problem with oracle 8.0.4.

i have following view
cum_fifo_figures
(

fnd_code varchar2(8),
txn_dt   date,
txn_no   number(3),
cum_unt  number(7),
cum_amt  number(7)

)

its in order of fnd_code,txn_dt,txn_no

I want to select value of cum_amt of previous row while selecting fnd_code,txn_dt,txn_no.

note : in case of first row it should select value from current row.

can anybody help me Please......

Kishan Thakker Received on Fri Jul 29 2005 - 06:46:15 CDT