In DB Remove Duplicates

[dalergreen]

Anyone know how to do a Unique function in DB?  I have I want to only have values in one field represented once.  I can do it outide of DB but can't figure out how to do it in DB.

Thanks 

Dale

[geraldo · Accepted solution]

@dalergreen 

in the db it is distinct 

summarize tool using group by for all fields
the union tool it is uniuon all if you want to represent the union of sql it is necessary to group by all the columns.

the summarize tool the problem when you don't use all the fields only the used fields that came out on the other side.

[dalergreen]

Thanks.  that works.