kishanthakker_at_gmail.com wrote:
> Dear Prochak,
>
>
>>>How do you define the "previous row" ?
>
>
> I M selecting in order of fnd_code,txn_dt,txn_no
>
> and I want in the same order previous row.
>
> I hope I M clear in my explanation.
>
> thanx
>
> regards
>
> Kishan Thakker
There is no such thing in a relational database heap table
as previous. How can "previous" be determined based on application
logic. The table, itself, has no such concept.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 01 2005 - 10:15:46 CDT
