--方法一
select * from tb_supply where rowid=any(select max(rowid) from tb_supply group by phone_id)
--方法二
select * from tb_supply where rowid in (select max(rowid) from tb_supply group by phone_id)
转载于:https://www.cnblogs.com/linjiqin/archive/2011/07/19/2110713.html