selecting unique data :)

[Anon]

I have a weeny little prob :-)

I have a field in a table that looks like this:

ID

DAM000010
DAM000010
PET006980
DAM000010
HIS006810
DAM000010

what I want to do is select only unique ID's. So I only want to select this:

DAM000010
PET006980
HIS006810

I dont want duplicate entries. I know you can use unique in SQL but Im not sure of the correct syntax.

If anyone could shed some light of this I would appreciate it :-)

[spider_man]

It's 'select distinct...'

[Anon]

Sweet 🙂

Thanks Palbo

Appreciate it.