create table tmp as select min(id) as col1 from test group by name,phone;
delete from test where id not in (select col1 from tmp);
drop table tmp;
select id,receiver,mobile,address from emall_trade where status='trade_finish' and amount>='500'
and id in (select min(id) from emall_trade where status='trade_finish' and amount>='500' group by mobile)
delete from test where id not in (select col1 from tmp);
drop table tmp;
select id,receiver,mobile,address from emall_trade where status='trade_finish' and amount>='500'
and id in (select min(id) from emall_trade where status='trade_finish' and amount>='500' group by mobile)