Hello, I want to print the records which are duplicates based on a Primary Key,if the key is duplicated I want to print the record with its each occurance.
I tried grouping by Key and then taking a count of each group and then including all Count>1. This trick works if I just want to see which records are duplicated. It shows each duplicated record only one time. However, I want to see its every occurance where information might be same or might be different in each field for that record.
I basically want to do what Access does with find duplicate query.
Can somebody help me with this.
Thanks.
I tried grouping by Key and then taking a count of each group and then including all Count>1. This trick works if I just want to see which records are duplicated. It shows each duplicated record only one time. However, I want to see its every occurance where information might be same or might be different in each field for that record.
I basically want to do what Access does with find duplicate query.
Can somebody help me with this.
Thanks.