select tb.* from
(select a,cc,max(d) dd from
(select a,max(c) cc from tb
group by a
) tba
group by a,cc
) tba
left join tb on tb.a=tba.a and tb.c=tba.cc and tb.d=tba.dd