Hi,
I have a GL data table as follows
CREATE TABLE vp_test (
class VARCHAR(255),
account VARCHAR2(255),
class_seq NUMBER,
net_movement NUMBER
);
--– Insert scripts
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('INCOME','Income -- 1',1,58629.6);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('INCOME','Income -- 2',1,-4125.49);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('INCOME','Income -- 3',1,18417.2);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('INCOME','Income -- 4',1,828349.34);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('COST OF GOODS SOLD','Cost Of Goods Sold -- 1',2,10076.21);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('COST OF GOODS SOLD','Cost Of Goods Sold -- 2',2,54668.22);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('COST OF GOODS SOLD','Cost Of Goods Sold -- 3',2,2803);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('COST OF GOODS SOLD','Cost Of Goods Sold -- 4',2,11303.8);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('EXPENSE','Expense -- 1',3,699.32);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('EXPENSE','Expense -- 2',3,359.46);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('EXPENSE','Expense -- 3',3,874.34);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('EXPENSE','Expense -- 4',3,3533.24);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('EXPENSE','Expense -- 5',3,1152.5);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('OTHER INCOME','Other Income -- 1',4,16910.75);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('OTHER INCOME','Other Income -- 2',4,34534.75);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('OTHER EXPENSE','Other Expense -- 1',5,53634.75);
Insert into VP_TEST (CLASS,ACCOUNT,CLASS_SEQ,NET_MOVEMENT) values ('OTHER EXPENSE','Other Expense -- 2',5,11212.75);
I am looking for a query to get the sub-totals as follows
Please suggest.
Thanks,