Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Remove duplicates
This should be simple for most of you...I want to remove duplicate e-mail addresses in my email field of my table called email_pft. so... DELETE FROM 'email_pft' WHERE email= ???? that if an address exists more than once delete all other instances but the first one??
