>I have a large table with one field that I need to check for duplicates.
>
>I know there is a way to do a SELECT statement to do this (if I recall correclty, you have to do some type of select/having statement or something like that? Anyone know how to do this?
>
>Thanks!

Select myfield from mytable group by 1 having count(*)>1