A. Select* from table where date=(select max(date) from table);
B. Select* from table t1 left join (elect max(date) as date from table) t2 on
t1.date=t2.date where t2.date is not null;
A. Select* from table where date=(select max(date) from table);
B. Select* from table t1 left join (elect max(date) as date from table) t2 on
t1.date=t2.date where t2.date is not null;