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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only