SELECT vendor, invoice_date, invoice_amount FROM mytable mt JOIN ( SELECT vendor, invoice_date, max(invoice_amount) AS invoice_amount FROM mytable mt1 ; WHERE invoice_date IN (SELECT max(invoice_date) FROM mytabel mt2 WHERE mt2.vendor = mt1.vendor) GROUOP BY vendor, invoice_date ) dt1 ON dt1.vendor = mt.vendor AND dt1.invoice_date = mt.invoice_date AND dt1.invoice_amount = mt.invoice_amount>Hi: