Thank you for your time, that command is working great. Now, is there an easy way to save the dup records in this table using a SELECT command?
>>Hello Erik,
>>The real table has 70 fields. Do I have to specify the 69 fields in the GROUP BY clause?
>>
>>>>I have a table with 5 fields and I'd like to get rid of the dup records base of 4 fields. The SELECT DISTINCT command doesn't work in this case because it compares the whole record.
>>>>
>>>>Any sugestions? Thank you in advance.
>>>
>>>you can choose your criteria for your uniqueness check with the GROUP BY clause:
>>>
>>>SELECT COUNT(*), * FROM Mytable GROUP BY Field1, Field2, Field3, Field4 HAVING COUNT(*) > 1
>
>The group by clause contains only the fields you want to use to determine uniqueness. If you are basiing your definition of uniquness on the contents of 4 fields, put those for fields in the GROUP BY clause.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement