发布网友 发布时间:2022-05-01 22:02
共5个回答
热心网友 时间:2023-10-05 10:36
select id,sfz,name,zp,max(time) from t group by name;热心网友 时间:2023-10-05 10:36
select id,sfz,name,zp,max(time)热心网友 时间:2023-10-05 10:36
select id,sfz,name,zp,time热心网友 时间:2023-10-05 10:37
select t.id,t.sfz,t.time from t t1 where exists热心网友 时间:2023-10-05 10:38
select a.* from tab a ,(select sfz,max(time) time from tab group by sfz) b where a.sfz=b.sfz and a.time=b.time;