select t.a, t.b, t.c
from t
  join (
    select a, b, max(date) as max_date
    from t
    group by a,b
  ) t2 on t2.a = t.a and t2.b = t.b and t.date = t2.max_date