[sql]
CREATE table temp as select max(id) as id FROM city_15 GROUP BY cityname ;
delete from city_15 where id not in (SELECT id from temp );
[/sql]
[sql]
CREATE table temp as select max(id) as id FROM city_15 GROUP BY cityname ;
delete from city_15 where id not in (SELECT id from temp );
[/sql]