select EDPNo, CaptureDate, ALertFlg from (select EDPNo, CaptureDate, ALertFlg, row_Number() over (partition by edpno Order by CaptureDate DESC) as RowNumber from ItemAlertFlgAudit ) D where RowNumber = 1