Re: Get "Youngest" Record in Child Table ?

SELECT ...
FROM(
SELECT NAME, LATEST_EVENT, ROW_NUMBER() OVER(PARTITION BY ID ORDER BY EVT_DATE DESC) RN
FROM ...
)T
WHERE T.RN = 1 Received on Wed Nov 24 2004 - 20:41:27 CST