select *
from a
where id in(select max(i) from a group by code,dt)---orselect *
from a
where exists(select * from a t where t.i>a.i and t.code=a.code and t.dt=a.dt)
from a
where id in(select max(i) from a group by code,dt)---orselect *
from a
where exists(select * from a t where t.i>a.i and t.code=a.code and t.dt=a.dt)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货