Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: cumulative of a variable
<anithaven_at_gmail.com> wrote in message
news:1149951451.368349.34970_at_f6g2000cwb.googlegroups.com...
> hi,
>
> suppose i have three variables with repeated records
> year own_no age
> 2001 5 21
> 2001 5 21
> 2001 5 21
> 2002 5 21
> 2002 5 21
> 2003 5 21
> 2003 5 21
>
>
> how do i update the age variable as per year
>
try to select rowid id, year, own_no, age from table, maybe the rowid pseudocolumn is what you looking for.. Received on Tue Jun 13 2006 - 01:40:00 CDT