Paintbox


Hello SQL gurus, can you help me with a problem.
I have an Access Database and a table containing a list of currency values.
I want to query this table to find out if there are any unique values, that is, an amount that only appears once in the table. Its probably very simple but I cannot work it out. The table is called Bids and the Field that I want to query is called Bids_value.
Any ideas would be greatly appreciated.




Re: UNIQUE VALUE

Kent Waldrop Jl07


You should be able to use a simple COUNT with a HAVING condition to determine this. If all you want is a list of the unique entries in a particular column:

Code Snippet

select columnName

from yourTable

having count(*) = 1

group by columnName

order by columnName