Re: Retrieving latest dates grouped by a key column value
All credit goes to Zachary Dionne.
SELECT id, date, subNo
FROM myTable
WHERE poNo=800 AND (date, subNo) IN(
SELECT MAX(date), subNo
FROM myTable
WHERE poNo=800
GROUP BY subNo)
GROUP BY subNo
ORDER BY subNo
Subject
Written By
Posted
November 30, 2022 08:00AM
Re: Retrieving latest dates grouped by a key column value
December 03, 2022 04:04AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.