My table is as follows
Id InvoiceNo Status Amt
1 ABC/1 Paid 100
2 ABC/2 Pending 200
3 XYZ Rejected 100
The result I want is as follows
Id InvoiceNo Status Amt
1 ABC Pending 300
2 XYZ Rejected 100
Kindly help me to get the solution. Thanks in advance.
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire