I've tried researching, and my best strategy I've got is to attempt to pull out data from the table, and then push the data against itself in order to remove all duplicates, ending up with a table of non-duplicates, which I can then 'minus set' over the original table, leaving me with duplicates.OPERATION (ID, PID, DID, Date, Time, Type)Is there anybody who is able to help me obtain a list of entries where there is more than 1 entry of a matching PID? I'm having issues working out exactly how to do what I've thought of, as well as, with relational algebra, is that the correct way?
Relational Algebra obtaining a list of duplicates
databases;relational algebra