I have a problem, I have data from a table that is duplicated, inside are the following fields
id, empresa, actividad, compañia I need the field
empresa is unique, I generate a query to know how many and which are duplicates and I need to delete. I did the query and it throws me the following results (I did it this way because I did not know how to put a table or better organized I hope to make myself understood) :
Empresa | Compañia | Total Empr1 | Compañia2 | 2 Empr2 | Compañia3 | 4 Empr3 | Compañia1 | 1
Now I need the company to have only one record per company How do I achieve it? or maybe that the company has only one record without importing the company How do I achieve it?
This is to be able to return in field