jeudi 1 février 2018

Get the recent value in MySQL

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