where a.date = (select max(Date) from table t1 where t1.idNumber = a.idNumber) and b.Date = (select max(Date) from table t2 where t2.idNumber = b.idNumber)