Querry to get unique records from

H

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

KARL DEWEY

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top