select * from A
left join
(select max(id) id,max(fieldA) fielda from A group by otherid )BB
on a.id=b.id and a.fieldA=b.fieldA
where b.id is not null
left join
(select max(id) id,max(fieldA) fielda from A group by otherid )BB
on a.id=b.id and a.fieldA=b.fieldA
where b.id is not null
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货