SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE Sales ( Region NVARCHAR(50), Order_Date DATE, Order_ID INT, Amount INT ); -- Insert sample data INSERT INTO Sales (Region, Order_Date, Order_ID, Amount) VALUES ('North', '2024-01-15', 1, 500), ('North', '2024-03-05', 5, 600), ('South', '2024-01-20', 2, 700), ('East', '2024-02-18', 4, 200); with cte as( select *, (1.00*sum(amount) over(partition by region order by order_date asc rows between unbounded preceding and current row ) /sum(amount) over(partition by region) )cum_sum from sales ) select * from cte order by region,order_date;

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear