Hello,
Create TABLE T1_TEMP(Reason VARCHAR2(10), Jurisdiction Varchar2(10) Pre-Approval NUMBER, Pending NUMBER, Approved NUMBER, Denied NUMBER);
Insert into T1_TEMP VALUES ('Home','J5','0','1','4','0');
Insert into T1_TEMP VALUES('Office','J5','0','2','5','2');
Insert into T1_TEMP VALUES('Travel','J5','0','3','7','1');
Insert into T1_TEMP VALUES('Home','J6','1','0','1','0');
Insert into T1_TEMP VALUES('Office','J6','1','0','2','0');
Oracle DB Version: Oracle 19c (Enterprise Edition Release 19.0.0.0.0)
Currently, when I query against the above table - T1_TEMP, I have the data in this format:
I am trying to get a grand total of Pre-Approval, Pending, Approved and Denied for each Jurisdiction.
Expected Result:
At the end of each Jurisdiction, I need a grand total of the categories.
Any help or suggestions would be greatly appreciated. Thank you!!!