Greetings

I manage a website wherein i keep track of the people
email who have downloaded my software and the version
number.

the structure is like -

id int auto_increment primary key,
email char,
version 

now the same person can download different version
therfore my table has data like this -

1,[EMAIL PROTECTED],1.0
2,[EMAIL PROTECTED],2.0
3,[EMAIL PROTECTED],3.0

Now I want to delete all the records wherein all rows
with duplicate email addresses are deleted so that i
have data like

1,[EMAIL PROTECTED],1.0
...

What should be the query? Thanks in advance.

Karam

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to