Finding duplicate records within a found set
The ! operator always searches for duplicate records within the entire table, so it doesn't produce the desired result when used to constrain a found set. Might somebody describe a procedure for finding duplicate records only within the found set? Thanks.