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.

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/2FyIhZM
via IFTTT