Answer 1

Sid, please consider that SQL can bring you the highest charge invoice of all and can group the invoices with a criteria provided by you, and from that group it can bring the highest one, but I'm just assuming that the filter is the highest charge, it could be the one with largest description counting the strings of a field, etc etc, please try to provide specifics.