条件可以自己加
select a.*
from table1 a
where not exists(select 1
from table1 b
where b.id=a.id and b.datetime>a.datetime);
);
条件可以自己加
select a.*
from table1 a
where not exists(select 1
from table1 b
where b.id=a.id and b.datetime>a.datetime);
);