thilak

• Jun 17th, 2013

 

Insert values into table(col1(10,20,30),col2(20,30,60),col3(30,40,60));

Sujatha N

• May 15th, 2014

 

Option 1:
If you need col2 to be created with manipulation on col1 when the table is created, you can refer to Virtual Columns concept in Oracle

Option 2:
If the real intention is only to display the sum while querying, here is the working code using analytical function – Lag

Code
SELECT Col1 , (Col1 + LAG(Col1, 1 ,0) over(PARTITION BY Col1 ORDER BY Col1 nulls LAST))  AS Col2


FROM Sample_Table;


 

Good Luck!!

vijaya lakshmi

• May 22nd, 2014

 

INSERT INTO TABLE VALUES(col1(10,20,30),col2(30,40,60));

pratik

• Jun 9th, 2014

 

We can use the analytical function LAG to achieve the desired result

Code
SELECT Col1, NVL(LAG(Col1, 1) over(ORDER BY Col1),0) AS col2, 


(Col1 + NVL(LAG(Col1, 1) 


over (ORDER BY Col1),0))  AS Col3


FROM Sample_Table;

kranthiswaroop

 Profile Answers by kranthiswaroop 

• Jun 16th, 2014

 

/* Formatted on 6/16/2014 5:08:51 PM (QP5 v5.114.809.3010) */
SELECT s,
CASE
WHEN rnk = 1
THEN
s
WHEN rnk > 1
THEN
(SELECT SUM (s)
FROM (SELECT s, RANK () OVER (ORDER BY s ASC) rnk1
FROM temp1)
WHERE rnk1 <= rnk)
END
s_add
FROM (SELECT s, RANK () OVER (ORDER BY s ASC) rnk FROM temp1)

kranthiswaroop

 Profile Answers by kranthiswaroop 

• Jun 16th, 2014

 

Hi Hraju,
Please check this code given, its works as per your scenario.

SELECT s,
CASE
WHEN rnk = 1
THEN
s
WHEN rnk > 1
THEN
(SELECT SUM (s)
FROM (SELECT s, RANK () OVER (ORDER BY s ASC) rnk1
FROM temp1)
WHERE rnk1 <= rnk)
END
s_add
FROM (SELECT s, RANK () OVER (ORDER BY s ASC) rnk FROM temp1)

Vinod Kumar G M

• Nov 7th, 2014

 

SELECT COL_NAME , SUM(COL_NAME) OVER ( ORDER BY COL_NAME) FROM TABLE_NAME

roshan.gwr

 Profile Answers by roshan.gwr 

• Mar 13th, 2015

 

Using Lag we can get it.
Select col1,col1+lag(col1,1,0) over (order by col1) col2 from table;