Re: hi

Select sno AS “SNO”,

SELECT  value AS “VALUE”,

 get_sum(value) as SUM

 from temp;

Hi

I have the data like this in temp table

SQL> Select sno, value from temp;

SNO                           Value

1                     650.00

2                     850.00

3                     640.00

3                     985.00

5                     987.00

9                     9864.00

7                     875.00

Now, I want display the result like this…

SQL> Select sno, value, get_sum(value) as sum from temp;

        SNO                   Value              SUM

1                     650.00             650.00

2                     850.00             1500.00           --650+850

3                     640.00             2140.00           --1500+640

3                     985.00             3125.00           -- 2140+985

5                     987.00             4112.00

9                     9864.00           13976.00

7                     875.00             14851.00

Any one can tell me query for this .. I don’t want any procedure or function…

Thanks & Regards

Penchal Reddy