select * from (
select b.* ,rank() over (partition by id_number order by 日志时间 desc ) rk from a,b where a.id_number=b.id_number) where rk=1;
select b.* ,rank() over (partition by id_number order by 日志时间 desc ) rk from a,b where a.id_number=b.id_number) where rk=1;
select * from a,(select * from b where id in (select max(id) from b group by id_number)) t
where a.id_number=t.id_number;
我不太明白,rank() over (partition by id_number order by 日志时间 desc 是什么意思?
谢了..