How do I create a query to eliminate duplicates? 2

[Taecca]

I only have 1 column with Items names, I need to eliminate duplicates, how can I do it?

 

[M8KWR]

group the column, then you will only get one of each type.

Hope this helps.

If you are unsure how to group then post your sql, and i will redo it for you.

 

[BNPMike]

Are you saying you have records with the same values when they shouldn't have? If so you need to tell us how you would (logically) select one for 'elimination'.

If you mean you wish to supress the same values repeating in queries, then do as M8KWR says or look at DISTINCT.

 

[Taecca]

I'll use select distinct.
Thank you