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
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