Querry to get unique records from

[haukalid]

I have an order-table with a column named "animalID". Some of the
animalID-records are duplicated. I would like to have a querry with only
unique animalID-records from both the duplicates and the rest of the records.

I.e. if there are 3 records of "123", 2 records of "456" and 1 record of
789, I would like a querry returning 1 record of each reagardless of the
number of records in the order-table.

 

[KARL DEWEY]

SELECT [order-table].animalID
FROM [order-table]
GROUP BY [order-table].animalID;

 

[Ron2006]

Select Distinct [order-table].animalID
FROM [order-table]



will also work

 

[Ron2006]

"Test" is a four letter word