How to remove duplicate records using LIbreOffice Base

asked 2019-06-14 00:58:54 +0200

I have a table with many duplicate records which need removing. I believe the process required is to use the SELECT DISTINCT command to select all the unique records (excluding the primary key - which would make every record unique) then use the INSERT command to add then to a new table. However, after creating an empty table matching the source table, if it includes the Primary Key it doesn't have the same number of columns as the SELECT DISTINCT output ( no Primary Key here, or else all records are unique by definition) - hence fails.

Hence I need some SQL which can locate all the records which are duplicate (excluding the PK), but list then with the key, or add a new one.

I could create the table without the PK, but base has great difficulty using tales with no Primary Key

edit retag flag offensive close merge delete



It would certainly help know the database being used. OS & LO version may also be of help. DISTINCT is probably not the method to use.

Ratslinger gravatar imageRatslinger ( 2019-06-14 02:53:42 +0200 )edit