Multiple SELECT query

[ilium007]

Hi - I am having probelms writing a query to select multiple items that are exactly the same in a table. I have about 4000 email addresses in a table that people have left and I intend to send an email to with MOJO. I would like to run a query however to find the ones people have left twice, and just select all dissimilar items.
Thanks in advance

 

[swampBoogie]

select distinct column_name from table_name

 

[tshot]

what i undesrtand from ur question is that u wish to find people who have left twice or more times.

then try the following

Select e-mail FROM table
group by e-mail
having count(e-mail) >= 2

swampBoogie cmd would give u all e-mails onece that is no duplicacy




----------------
ur feedback is a very welcome desire