You need to determine if there are any duplicates in a column; here's a quick way to do that with a couple count() functions:

sql> select count(field), count(distinct field) from table where...

If the counts are the same, you're duplicate free!

Thanks to McG for the tip.