Deleting duplicating records

[Karam Chand]

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,my***@mysql.com,1.0
2,my***@mysql.com,2.0
3,my***@mysql.com,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,my***@mysql.com,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/my***********...ie.nctu.edu.tw