sql 删除重复记录，只保留ＩＤ号最小（或最大）的一条

delete from SimNetInfo
where imsi in (select imsi from SimNetInfo group by imsi having count(imsi) > 1)
and id not in (select min(id) from SimNetInfo group by imsi having count(imsi)>1)

语句解释：
找出有重复的记录，并查出其中id号最小的id:
select min(id) from SimNetInfo group by imsi having count(imsi)>1　

找出所有重复记录的imsi，并按关键字分组：
select imsi from SimNetInfo group by imsi having count(imsi) > 1

删除所有的有重复的imsi　并将最小的id的那一条排除。