delete from mgo_iosapp_info
where id not in (
select id from (
select MAX(id) as id ,count(deviceToken) as count from mgo_iosapp_info GROUP BY deviceToken HAVING count >0) as tab)
where id not in (
select id from (
select MAX(id) as id ,count(deviceToken) as count from mgo_iosapp_info GROUP BY deviceToken HAVING count >0) as tab)