hELLO,
Need help to output Total based on Supplier Data as below:
CREATE TABLE TAB_SUP
(
SUP_NAME VARCHAR2(30),
PAY_DATE DATE,
PAID_MT NUMBER,
CHECK_NUM NUMBER,
INVOICE_NUM NUMBER);
INSERT INTO TAB_SUP
VALUES
(
'ABC','01-JAN-2016',60,1234,9999);
INSERT INTO TAB_SUP
VALUES
(
'ABC','04-JAN-2016',60,1235,9998);
INSERT INTO TAB_SUP
VALUES
(
'DEF','04-JAN-2016',60,1111,9777);
INSERT INTO TAB_SUP
VALUES
(
'DEF','07-JAN-2016',70,1237,9888);
COMMIT;
I need to represent the lines as
Sup_Name Pay_Date Paid_Amt Check_Num Invoice_Num
ABC 01-JAN-2016 60 1234 9999
ABC 04-JAN-2016 60 1235 9998
Total:120
DEF 04-JAN-2016 60 1111 9777
DEF 07-JAN-2016 70 1237 9888
Total:130