identifying duplicate records from a subquery
I have a table MV_AIRPORT...I have a created the following subquery to get the most updated recorded from this table...but I still want to know if there are any duplicates.
Select * from MV_AIRPORT_ALL t
where t.AUDIT_UPDT_DATETIME= (Select max(AUDIT_UPDT_DATETIME) from MV_AIRPORT_ALL where
AIR_CNTL_NUMBER=t.AIR_CNTL_NUMBER and AIR_REVISION_NUMBER= t.AIR_REVISION_NUMBER)