I have table with col1 values , col2 1st row value should be same col1 1st row, then col 2 row onwards row each should added each row values eg: col1 values 10,20,30. Etc, in col2 values display like 10, 30,60 etc. how we can write sql query ?
/* 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)
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
Write sql query to get the below required output
Questions by hraju_tt
Related Answered Questions
Related Open Questions