How can i create an SQL Statement based on fields that appears more than once in a table?

Thank you once again!

If you mean how can you only show one example of each then use the following:

Select Distinct (your_field_name)
from yourtablename


Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com
(Now completely CSS based and bye bye to all tables!)

VBScript | ASP | HTML | CSS | SQL | Oracle | Hosting

no it's not what i mean<img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

I want to get the duplicate records ( records that appear with the same value more than once) based on one field (not the primary since it can't be duplicate)