hi! i have a table with alot duplicates in them. the tables has about 2 million rows and i expect that there are ca. 20.000 duplicates which have to be removed.. what i basicly wanna do is: delete rows from that table which have the same value on the column col1, col2 and col3 of that table. now the tricky part though: i only wanna keep the row with the highes fooId in that table.. all other duplicates should be deleted.. for example when i have those rows: fooId col1 col2 col3 1 bla yo orange 2 bla yo orange 3 bla yo orange 4 super yo orange 5 hey hey hey 6 hey hey hey it should delete the rows with the fooId: 1, 2 and 6... whats the easiest way to do that stuff with mysql? thanks alot in advance =) ciao! florian -- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php